The following formula needs to check another variable:
=IFERROR(IF($AH3<=$C$38,0,IF(OR(MIN($F3,$M3,$T3,$AA3)<$C$37,I3<10),($C$39)*I3*$E3/I3,$C$43))*I3,0)
If E3 > C41 then E3 = C41 else E3 = E3
As an example, E3 has a value of £12, but if E3 exceeds £16 then the maximum we can allow is £16
Does this make sense ?
Cheers
Help with Formula
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Help with Formula
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 80032
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Help with Formula
Is the formula that you posted in E3? If so:
=MIN(IFERROR(IF($AH3<=$C$38,0,IF(OR(MIN($F3,$M3,$T3,$AA3)<$C$37,I3<10),($C$39)*I3*$E3/I3,$C$43))*I3,0),$C$41)
=MIN(IFERROR(IF($AH3<=$C$38,0,IF(OR(MIN($F3,$M3,$T3,$AA3)<$C$37,I3<10),($C$39)*I3*$E3/I3,$C$43))*I3,0),$C$41)
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Re: Help with Formula
Morning Hans, thank you for the solution. It was easier in the end to create another tab and re-create the same formula and just point it to look elsewhere, same result.
Again, many thanks.
Again, many thanks.
Cheers ...
Dave.
Dave.