Help with Formula

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Help with Formula

Post by D Willett »

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
Cheers ...

Dave.

User avatar
HansV
Administrator
Posts: 78071
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Help with Formula

Post by HansV »

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)
Best wishes,
Hans

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Re: Help with Formula

Post by D Willett »

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.
Cheers ...

Dave.