ExcelBanter - Min. Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Min. Formula (https://www.excelbanter.com/excel-discussion-misc-queries/231687-min-formula.html)

Canon

Min. Formula

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

Min. Formula

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

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

Domenic[_2_]

Min. Formula

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

All times are GMT +1. The time now is 02:52 PM.