In article ,
Canon wrote:

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)

--
Domenic
http://www.xl-central.com