| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
