Min. Formula

C

Canon

Excel 2007
I have the following formula in cell F15;
=sum((D15*E15)/144*A15
I need to have cell F15 at a minimum of 3.00 - then use the above formula.
 
D

Domenic

Canon said:
Excel 2007
I have the following formula in cell F15;
=sum((D15*E15)/144*A15
I need to have cell F15 at a minimum of 3.00 - then use the above formula.
Click to expand...


Try...

=MAX(3,(D15*E15)/144*A15)
 
Top