how do i use the roundup function

L

Leprechan

I have prepared salary scales using simple formulas where the calculations
are based on a % increase. I would like the answers to be rounded up eg:
$27.997 to be $28.00. I am unclear on how to apply the roundup function ( I
believe that is the one I s/b using..) Do I use roundup in the initial
formula & then copy across the page? Can someone pls provide me with an
example.

Thanks
Debbie
 
M

Mike H

Hi,

You can round up the result of the increase using

=ROUNDUP(A1,0)

or do it all in 1 go

=ROUNDUP(A1*1.03,0)

Mike
 
J

JLatham

ROUNDUP() needs 2 pieces of information: the value to be rounded and the
number of digits to round to. The value to be rounded can be a calculated
value. So...
Lets say you have a starting pay rate in A1 such as 28.50 and you want to
calculate what a 3% raise would bring it to in B1. In B1 you'd put this
formula:
=ROUNDUP(A1 * 1.03,2)
which should display 29.36. If you fill the formula to the right, into
columns C and D, you'd see 30.25 in C1 (the 29.36 now in B1 multiplied by
1.03) and 31.16 in D1, which is the 30.25 in C1 multiplied by 1.03 again.

Whether to use ROUNDUP() or ROUND() depends on how you want to treat
portions of your results beyond the pennies: ROUNDUP() will always round up,
so a result of 12.3322 would be rounded to 12.34, while ROUND() follows the
rules we learned in school, and 12.3322 would round down to 12.33 while
12.3351 would round up to 12.34.

Hope this helps.
 
W

willemeulen

Roundup works up to 1 decimal, if you want let say round it up to the 10
(11 becomes 20, 25 becomes 30 etc you could use the CEILING FUNCTION

Cheers

W
 
B

Bernard Liengme

Debbie<
You example is not necessarily round UP; 27.997 rounds to 28
A normal rounding of 27.3 would be 27 while a round UP would be 28

I will assume you do want to round up and I will use the ROUNDUP function.
If you want just simple rounding, change it to ROUND

Suppose A1 holds the current salary and you want a 12.5% increase rounded up
to the nearest dollar:
In B1 use this formula =ROUNDUP(A1*1.125,0) or if you prefer
=ROUNDUP(A1+A1*12.5%,0)
The zero here tells Excel to roundup to an integer (no decimals / no cents
in this case)

If A2 has the next person's salary just copy the formula down the column by
dragging or double clicking B1's fill handle (small solid square in the
lower right corner when the cell is selected)
If your data goes across the worksheet you can bout the formula in the cell
below and drag across the row.

best wishes
 
D

David Biddulph

If you can't use Excel help for the ROUNDUP function, you may need to
reinstall Excel..
 
L

Leprechan

Thanks for your help.
Debbie

JLatham said:
ROUNDUP() needs 2 pieces of information: the value to be rounded and the
number of digits to round to. The value to be rounded can be a calculated
value. So...
Lets say you have a starting pay rate in A1 such as 28.50 and you want to
calculate what a 3% raise would bring it to in B1. In B1 you'd put this
formula:
=ROUNDUP(A1 * 1.03,2)
which should display 29.36. If you fill the formula to the right, into
columns C and D, you'd see 30.25 in C1 (the 29.36 now in B1 multiplied by
1.03) and 31.16 in D1, which is the 30.25 in C1 multiplied by 1.03 again.

Whether to use ROUNDUP() or ROUND() depends on how you want to treat
portions of your results beyond the pennies: ROUNDUP() will always round up,
so a result of 12.3322 would be rounded to 12.34, while ROUND() follows the
rules we learned in school, and 12.3322 would round down to 12.33 while
12.3351 would round up to 12.34.

Hope this helps.
 
L

Luke M

You can actually use negative numbers to indicate how many places left of
decimal to round.
E.g.,

=ROUNDUP(11,-1)
evaluates to 20.

CEILING is nice for when you need to roundup to a common multiple of a
number other than 10.
E.g.
=CEILING(11,5)
evaluates to 15.
 

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

Top