## Help with Formula

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

### Help with Formula

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.

HansV
Posts: 78071
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)
Best wishes,
Hans

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

Dave.