S
sdmccabe
I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?
formula to accomplish this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nikki
if your number is in cell A1, use =round(A1,0).
nikki
nikki
E
Elkar
You could use the ROUNDUP formula.
=ROUNDUP(your formula,0)
The zero above represents how many decimal places you want to round to.
HTH,
Elkar
=ROUNDUP(your formula,0)
The zero above represents how many decimal places you want to round to.
HTH,
Elkar
D
Duke Carey
If you truly want to round UP, use
=ROUNDUP(your formula, # of digits)
otherwise use
=ROUND(your formula, # of digits)
see Excel's help file for more info
=ROUNDUP(your formula, # of digits)
otherwise use
=ROUND(your formula, # of digits)
see Excel's help file for more info
S
sdmccabe
The formula that exists in the cell is =(a1+b1). How would I add the round
formula?
formula?
N
Nikki
=round(a1+b1,0)
or:
=roundup(a1+b1,0)
or:
=roundup(a1+b1,0)
sdmccabe said:The formula that exists in the cell is =(a1+b1). How would I add the round
formula?