Is the syntax correct?

[Kvin]

Is this syntax correct:

=ROUNDUP((I35+I38),2)

(need ROUNDUP sum.)

 

[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

 

[Kvin]

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.

 

[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

 

[Kvin]

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.

 

[mistral]

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.