Rounding Up in Cells With Formulas

[Guest]

Current formula:
=SUM(CJ:CP14) formatted, as number to 2 places displays 861.74.
Formatted number 0 places displays 862.

Regardless of formatting, other cells using this cell result, use 861.74,
how can I get the other cells to use the rounded up number.

THX

 

[Guest]

Assuming you want it rounded to the nearest integer change formula to

=ROUND(SUM(CJ:CP14),0)

 

[Guest]

I notice that your range contains a typo, of course formula needs to be
something like

=ROUND(SUM(CJ1:CP14),0)

 

[PCLIVE]

If you want to round UP to the nearest integer, then:

=ROUNDUP(SUM(CJ1:CP14),0)

Regards,
Paul