Formula
 

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?

Formula
 

if your number is in cell A1, use =round(A1,0).

nikki

"sdmccabe" wrote:

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?

Formula
 

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

"sdmccabe" wrote:

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?

Formula
 

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


"sdmccabe" wrote:

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?

Formula
 

The formula that exists in the cell is =(a1+b1). How would I add the round
formula?

"Nikki" wrote:

if your number is in cell A1, use =round(A1,0).

nikki

"sdmccabe" wrote:

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?

Formula
 

=round(a1+b1,0)
or:
=roundup(a1+b1,0)

"sdmccabe" wrote:

The formula that exists in the cell is =(a1+b1). How would I add the round
formula?

"Nikki" wrote:

if your number is in cell A1, use =round(A1,0).

nikki

"sdmccabe" wrote:

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?