| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min. Formula
Excel 2007
I am using the following formula, =CEILING(1*(G6*$I$2),5/100) but I would like to set a minimum amount of 25.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Min. Formula
To set a minimum value, use the MAX function.
=MAX(CEILING(1*(G6*$I$2),5/100),25) -- David Biddulph "Canon" wrote in message ... Excel 2007 I am using the following formula, =CEILING(1*(G6*$I$2),5/100) but I would like to set a minimum amount of 25.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Min. Formula
To set a minimum amount, use the MAX function.
=MAX(CEILING(G6*$I$2,5/100),25) Could you please explain to us what the 1* is doing for you in your formula? -- David Biddulph "Canon" wrote in message ... Excel 2007 I am using the following formula, =CEILING(1*(G6*$I$2),5/100) but I would like to set a minimum amount of 25.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
