If statement not working properly.

**jstawski** · 03-26-2013, 02:37 PM

I am writing code to interpolate data. I want to the code recoginaze which values were given by the user and write those. I have an ifstatement in VBA to determine if the associated value was given. code:

Please Login or Register  to view this content.

The if statement "If cell1 = cell2 Then" doesn't recognize when cell1 = cell2. i tried adding .value which didn't work. I also tried formatting to equal the same. I added an if statement in excel to check if the two were really equal and they were. The peculiar thing, is the routine works for two of the data pairs I have but not for the third. Suggestions?

**rylo** · 03-27-2013, 01:02 AM

Hi

Worked for me on my dummy up version. How about you add an example file.

rylo

**JosephP** · 03-27-2013, 03:03 AM

I reckon you're probably dealing with very small decimal differences-try rounding the values to a set number of decimal places before you compare them

**jstawski** · 03-27-2013, 09:31 AM

Thanks for the replies. Turns out it was a rounding error. excel stores 15 decimal places while VBA stores much more than that. After rounding the answer, I was able to get the program to run. Thanks for the help.