Why My IF is not TRUE

**cferoiu** · 03-07-2011, 04:15 PM

I want to escape from the first for, but I was stuck ...
The condition is false, even if the variables are correct ...
Can someone help me?

**barryleajo** · 03-07-2011, 05:10 PM

Is Sheets("Statistics") selected?

**Colin Legg** · 03-07-2011, 05:21 PM

Hi,

I was able to replicate your problem with this simple example:

Please Login or Register  to view this content.

It's a rounding issue due to the way Excel computes and stores numbers under the hood. See if converting to the Currency Data Type is acceptable for you, which will allow for 4 decimal places:

Please Login or Register  to view this content.

**cferoiu** · 03-08-2011, 03:45 PM

Another stupid thing from MS

I declared variable to single, double... nothing works.
I force variable with CDbl... nothing.
2 day lost because this ****.

Solution: -------------------- CCur -----------------------

Thank you very much Colin.

**cferoiu** · 03-08-2011, 03:47 PM

I don't know how i do "SOLVE"

**shg** · 03-08-2011, 03:47 PM

It has nothing to do with Microsoft; it is a result of your computer's use of IEEE 754 binary floating point numbers.

**cferoiu** · 03-08-2011, 03:54 PM

I don't know what it is IEEE754 but stil MS it is.
I don't modify anything from settings.
IEEE754, IEEE64 etc. is not my problem.

XP, Vista, Win7, x86, x64, etc. is not my problem.

My problem is was a simple variable with value 2 , and condition FALSE!!!!!!!!!!!!!!!

**shg** · 03-08-2011, 04:08 PM

I have a dog that barks at the moon ...

**cferoiu** · 03-08-2011, 04:13 PM

In loc sa scri poezi mai bine imi explicai ce e cu acel IEEE754 si in ce context trebuie eu sa visez unde e problema.
Stima domnule shg si cautati de lucru in alta parte.