Rounding up

[Gary]

Is there a way to round up a number as soon as it becomes higher than the
whole number?

I am writing a painting estimating file, and would like for the number to
always round up, so for example, if I need 10.01 gallons of paint, it
becomes 11 gallons of paint.

Thanks

Gary

 

[Rick Rothstein]

Do you mean in the cell the number is entered in? Or in another formula that references that cell (for example, the cell where you multiply the gallons by the price per gallon)? If you mean the same cell, would require VB coding (which would physically change the cell value from what you typed to the rounded value). If, on the other hand, you meant 'in another cell that references it', then use the ROUNDUP function...

=ROUNDUP(A2,0)*B2 {(where B2 is assumed to have the price per gallon}}

 

[Gary]

Thanks, I've never really worked with formulas in excel before, so what I am
doing is taking the wall length x height x number of coates to equal the
square footage to be covered, divided by the amount of paint required to
cover the wall, to come up with the number of gallons needed.

13'x8'x2=208/300=.66 of a gallon, to be rounded up to 1 gallon.


Do you mean in the cell the number is entered in? Or in another formula that
references that cell (for example, the cell where you multiply the gallons
by the price per gallon)? If you mean the same cell, would require VB coding
(which would physically change the cell value from what you typed to the
rounded value). If, on the other hand, you meant 'in another cell that
references it', then use the ROUNDUP function...

=ROUNDUP(A2,0)*B2 {(where B2 is assumed to have the price per gallon}}

 

[Rick Rothstein]

You don't give any hints as to the layout of your data; so, if I have guessed wrong, you will have to adjust the formulas to match your actual conditions. Assuming the wall length is in A2, the height is in B2, the number of coats is in C2 and that the 300 is a fixed value...

=ROUNDUP(A2*B2*C2/300,0)

 

[Gary]

For what ever reason, I cannot get this to work, I keep getting an error
message that I have used too few arguements for the function.

I have entered =ROUNDUP(N3/300)

What am I missing here.


You don't give any hints as to the layout of your data; so, if I have
guessed wrong, you will have to adjust the formulas to match your actual
conditions. Assuming the wall length is in A2, the height is in B2, the
number of coats is in C2 and that the 300 is a fixed value...

=ROUNDUP(A2*B2*C2/300,0)

 

[Rick Rothstein]

You missed the ,0 (comma/zero). Try this...

=ROUNDUP(N3/300,0)

 

[John]

Hi

Maybe this > =ROUNDUP(N3/300,0)
HTH
John

For what ever reason, I cannot get this to work, I keep getting an error
message that I have used too few arguements for the function.

I have entered =ROUNDUP(N3/300)

What am I missing here.


You don't give any hints as to the layout of your data; so, if I have
guessed wrong, you will have to adjust the formulas to match your actual
conditions. Assuming the wall length is in A2, the height is in B2, the
number of coats is in C2 and that the 300 is a fixed value...

=ROUNDUP(A2*B2*C2/300,0)

 

[Gary]

Rick, John, many thanks.

One more item, how do I change my undo preferences...I would like to have
more than one undo..

Again, thanks for all your help.

gary