Rounding up the result
 

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

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"cubus" wrote in message
...
How rounding up the sum result? Cell formula is: =I35+I38, it show result
1268.99, I need get result 1269.00

On Thu, 13 Jan 2005 14:30:40 +0200, "cubus" wrote:

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

=ROUNDUP(I35+I38,0)

--

HTH

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


"cubus" wrote in message
...
How rounding up the sum result? Cell formula is: =I35+I38, it show result
1268.99, I need get result 1269.00

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

"cubus" wrote:

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

"nick.pattison" wrote in message
...
use =ROUND(I35+I38) and display to 2 decimal places

"cubus" wrote:

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

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..

check the other posts.

--

HTH

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


"cubus" wrote in message
...

"nick.pattison" wrote in message
...
use =ROUND(I35+I38) and display to 2 decimal places

"cubus" wrote:

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

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..

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

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.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"cubus" wrote in message
...

"nick.pattison" wrote in message
...
use =ROUND(I35+I38) and display to 2 decimal places

"cubus" wrote:

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

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..

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


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.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"cubus" wrote in message
...

"nick.pattison" wrote in message
...
use =ROUND(I35+I38) and display to 2 decimal places

"cubus" wrote:

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

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..

On Thu, 13 Jan 2005 16:11:26 +0200, "cubus" wrote:

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

"Ron Rosenfeld" wrote in message
...
On Thu, 13 Jan 2005 16:11:26 +0200, "cubus" wrote:

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

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..

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

"cubus" wrote in message
...

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.

On Fri, 14 Jan 2005 14:16:53 +0200, "cubus" wrote:

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