Min. Formula

  • Thread starter Thread starter Canon
  • Start date Start date
C

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
 
To set a minimum value, use the MAX function.

=MAX(CEILING(1*(G6*$I$2),5/100),25)
 
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?
 
Back
Top