Help with Formula

[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

[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)

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