How do i round up the sum of a formula

[ian]

I woul like to round up the sum of a formula

=K11+(M7*25%)

=115+(22*25%)=120.5 shouldshow 121

[bgeier]

The "0" determines the number of decimal places.

=ROUNDUP(115+(22*25%),0)

[Norman Jones]

Hi Ian,

Try:

=ROUND(115+(22*25%),0)

See also the ROUNDUP and ROUNDDOWN functions in Excel help.


---
Regards,
Norman



"ian" <[email protected]> wrote in message
news:[email protected]...
>I woul like to round up the sum of a formula
>
> =K11+(M7*25%)
>
> =115+(22*25%)=120.5 shouldshow 121
>
>