K
Kvin
Is this syntax correct:
=ROUNDUP((I35+I38),2)
(need ROUNDUP sum.)
=ROUNDUP((I35+I38),2)
(need ROUNDUP sum.)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
What's in I35 and I38?
What result do you get when you enter the formula in a cell?
What result do you want?
Gord Dibben MS Excel MVP
What result do you get when you enter the formula in a cell?
What result do you want?
Gord Dibben MS Excel MVP
K
Kvin
----------------------------Gord Dibben said:What's in I35 and I38?
What result do you get when you enter the formula in a cell?
What result do you want?
Gord Dibben MS Excel MVP
That is Invoice calculation.
I35 column formula is: =SUM(I23:I34) -> data is 607.37
I38 column formula is: =I35*0.18 -> data is 109.33
I39 column formula is(this is total sum): =(I35+I38) -> but show wrong
sum: 716.99 (must be 716.70, however).
So i want roundup.
Thanks.
G
Gord Dibben
What do you see in the formula bar when you increase the decimal places in I35
and I38?
I suspect you do not have exactly 607.37 and 109.33 and that is why you are
getting what you think is an incorrect result of 716.99, which I think is a typo
and you maybe meant 716.69
Try =ROUND(I35+I38,1)
Gord
and I38?
I suspect you do not have exactly 607.37 and 109.33 and that is why you are
getting what you think is an incorrect result of 716.99, which I think is a typo
and you maybe meant 716.69
Try =ROUND(I35+I38,1)
Gord
K
Kvin
Gord Dibben said:What do you see in the formula bar when you increase the decimal places in
I35
and I38?
I suspect you do not have exactly 607.37 and 109.33 and that is why you
are
getting what you think is an incorrect result of 716.99, which I think is
a typo
and you maybe meant 716.69
Try =ROUND(I35+I38,1)
What result do you get when you enter the formula in a cell?
What result do you want?
Gord Dibben MS Excel MVP
Is this syntax correct:
=ROUNDUP((I35+I38),2)
(need ROUNDUP sum.)
---------------------------------------------
When I increase the decimal places in I35 and I38, the formula does not
change, numbers change in I35 -> 607.366 and in I38 -> 109.326. Yes, I meant
716.69
K.
M
mistral
---------Kvin said:Is this syntax correct:
=ROUNDUP((I35+I38),2)
(need ROUNDUP sum.)
----------------------------
-----------------
When I increase the decimal places in I35 and I38, the formula does not
change, numbers change in I35 -> 607.366 and in I38 -> 109.326. Yes, I meant
716.69
K.
Any ideas about this issue? I want minimize possible errors and failures in
the further.
K.