Min. Formula

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
 
D

David Biddulph

To set a minimum value, use the MAX function.

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to formula 2
Search formula showing results plus 100 characters 2
Change cell colour 2
Combine 2 formulas 14
IF Statements 1
Help!! To modify existing formula 1
Want To Shrink Formula 1
Ceiling problem. 3

Top