Challange !! Despite all of the calculations are 0 = 0 some cells gives FALSE

[Ozdemiroz]

Hello guys,

When calculating all round formulas in K17:K22 with F9 the result is always equal to 0

But despite all of the calculations are 0 = 0 some cells gives FALSE and others gives TRUE.

They all must be TRUE.

What is the problem of these formulas ?

Good luck.

 

[awoohaw]

I don't know what to think with no column and row letters/numbers. Can you give the column names we need to be looking at?

 

[awoohaw]

It is probably the floating point decimal issue. But, why haven't you put a ROUND() function on the second half of your equations (C11, C12, etc.)?

=ROUND(C18*C$7,4)-ROUND(C11,4)

 

[Ozdemiroz]

Now all rows and columns name's are visible.

 

[Ozdemiroz]

It is probably the floating point decimal issue. But, why haven't you put a ROUND() function on the second half of your equations (C11, C12, etc.)?

=ROUND(C18*C$7,4)-ROUND(C11,4)

Thank you very much. The problem is solved. But it still interesting. Despite I did not use Round for the second half of the formula, they are already 0 = 0
Thank you again.

 

[awoohaw]

Thank you very much. The problem is solved. But it still interesting. Despite I did not use Round for the second half of the formula, they are already 0 = 0
Thank you again.

i'm confused. Why haven't you posted how you solved the question?

 

[Ozdemiroz]

i'm confused. Why haven't you posted how you solved the question?

I solved with your method. I added a round formula too for the second half of the entire formula…

 

[awoohaw]

Okay. I'm happy it worked. I guess I read your statement wrong when you wrote already 0=0. It is just the way that excel processes numbers. If you set the format of the unrounded values you may get a very very very tiny amount that is not zero.