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/254091-min-formula.html)

Canon

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

David Biddulph[_2_]

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

David Biddulph[_2_]

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

All times are GMT +1. The time now is 02:31 AM.