Min. Formula

[Canon]

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]

To set a minimum value, use the MAX function.

=MAX(CEILING(1*(G6*$I$2),5/100),25)

 

[David Biddulph]

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?