Hello.

I have a result of $300.00 in cell G9

The formula in cell G9

IF(AND($F9=1,$C$19>$D9, $E9>0),MIN($G$3,$G$4,$G$5,$C$19*C9*$I$9,$C9*$E9),I F(AND($F9=1,$C$19<$D9, $E9=0),MIN($G$3,$G$4,$G$5,$D9*$I$9), IF(AND($F9=1,$C$19>$D9, $E9=0),MIN($G$3,$G$4,$G$5,$C$19*$I$9), 0)))

The below formula is in cell G10

=IF(AND($F10=1,$C$19>$D10, $E10>0, $G9<$G$3),MIN($G$3,$G$4,$G$5,$C$19*C10*$I$9, $C10*$E10), IF(AND($F10=1,$C$19<$D10, $E10=0),MIN($G$3,$G$4,$G$5,$D10*$I$9), IF(AND($F10=1,$C$19>$D10, $E10=0),MIN($G$3,$G$4,$G$5,$C$19*$I$9), 0)))

G9 shows the result being the minimum of the min criteria (which is fine) is this the most effective formula though?

The formula was then adjusted (in cell G9) to include if the limit (being $300.00 & cell G4 was depleted then any further results from then on based on the above formula would be zero as the minimum criteria is no longer valid (using if(and)

I have copied the formula but maybe there is either a better way or my formula has errors in it

Thank you