Formula

[sdmccabe]

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

[Nikki]

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?

[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

"sdmccabe" wrote:

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

[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


"sdmccabe" wrote:

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

[sdmccabe]

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?

[Nikki]

=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?