Rounding up the result

[cubus]

How rounding up the sum result? Cell formula is: =I35+I38, it show result
1268.99, I need get result 1269.00

 

[Arvi Laanemets]

Hi

=ROUNDUP(SUM(...),0)

 

[Ron Rosenfeld]

How rounding up the sum result? Cell formula is: =I35+I38, it show result
1268.99, I need get result 1269.00

=ROUNDUP(your_formula,0)


--ron

 

[Bob Phillips]

=ROUNDUP(I35+I38,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

use =ROUND(I35+I38) and display to 2 decimal places

 

[cubus]

use =ROUND(I35+I38) and display to 2 decimal places

Its incorrect formula and not work. What I need is get 1269.00 result
instead of 1268.99

Cell I35 result is 1075.42, cell I38 result is 193.58, so normally it must
show sum 1269.00 without any additional adjusting, but it show 1268.99. It
strange..

 

[Bob Phillips]

check the other posts.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[cubus]

Cell formula is: =I35+I38, it show result 1268.99.
But cell I35 result is 1075.42, cell I38 result is 193.58, so normally it
must show sum 1269.00 without any additional adjusting, but it show 1268.99.
Why? It strange..

How rounding up the sum result? I need get 1269.00

 

[Arvi Laanemets]

Hi

Set cell format for I135 and I138 to Numeric with 15 decimals - I'm sure
you'll see now why you have such result.

 

[cubus]

Hi
this not help. I just see 1075.420000000000000....

 

[Ron Rosenfeld]

Cell formula is: =I35+I38, it show result 1268.99.
But cell I35 result is 1075.42, cell I38 result is 193.58, so normally it
must show sum 1269.00 without any additional adjusting, but it show 1268.99.
Why? It strange..

It's not strange at all. Although cell I38 shows 193.58 and cell I35 shows
1075.42, that is not the number that is really in those cells.

What happens if you manually enter those values into the cells (as opposed to
having them there as the result of some computation)?

What do you see in EACH cell when formatted as number with 15 decimal places?

How rounding up the sum result? I need get 1269.00

What did not work when you used the ROUNDUP formula previously suggested by at
least three people? We need to know this in order to help you.


--ron

 

[cubus]

It's not strange at all. Although cell I38 shows 193.58 and cell I35
shows
1075.42, that is not the number that is really in those cells.

What happens if you manually enter those values into the cells (as opposed
to
having them there as the result of some computation)?

What do you see in EACH cell when formatted as number with 15 decimal
places?


What did not work when you used the ROUNDUP formula previously suggested
by at
least three people? We need to know this in order to help you.


--ron

Yes, =ROUNDUP(I35+I38,0) ROUNDUP formula work, I got correct result.
And really, when I manually enter 1075.42 value into I35 cells, I got right
result.
But it looks very suspicious, that the microsoft distributes programs which
show the false data which confuse peoples..

*****************

 

[Bob Phillips]

Yes, =ROUNDUP(I35+I38,0) ROUNDUP formula work, I got correct result.
And really, when I manually enter 1075.42 value into I35 cells, I got right
result.
But it looks very suspicious, that the microsoft distributes programs which
show the false data which confuse peoples..

It only confuses if you don't understand what is happening. Re-read Ron's
reply, and understand what happens and why.

 

[Ron Rosenfeld]

But it looks very suspicious, that the microsoft distributes programs which
show the false data which confuse peoples..

Suspicious? Hardly. You need to better understand how these tools work. The
program is doing exactly what the documentation says it does.


--ron