Formula to Include Rounding a Number

[picktr]

here is my current formula:

=SUM(L3-E3)

I need the result of this to be a rounded number, up
or down, 0 decimal places. It is important to round
the number UP or Down.

I can't use "format cell" on this one, as I cut and
past special this range of cells, and it is used in
another calculation which needs to be
a rounded number, 0 decimal places

 

[AlfD]

Hi!

You say =sum(L3-E3). Perhaps =sum(E3:L3) ?

Anyway: you want to round this number - so far as I can tell
physically, permanently.

To what accuracy do you want to round? Integer? 2 d.p.? Nearest 100?

Tell me more.

Al

 

[picktr]

zero d.p's

if 43.3563 then 43
if 43.525 then 44

thanks

 

[picktr]

please refrase the following formula
to INCLUDE rounding up or down;

=sum(L3-E3)

Is this an IF argument

 

[AlfD]

Hi!

Nope.
Just enter =round(sum(E3:L3),0)

I'm just a bit anxious about your L3-E3. Am I missing something or am
right to assume you want to sum the row 3 items from column E to colum
L

Al

 

[picktr]

THANK YOU! THANK YOU!

I'M DONE, YEAH!!!!!!!!!!!!!!

 

[AlfD]

Well....

Thank goodness for that!!!!

Al