Min. Formula

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

 

[Sean Timmons]

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

 

[Domenic]

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.

Try...

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