Comparing using "If" function
When I input =if(ab5=ab6,"yes","no")
I continually get a "no" because ab5 = 10.00001
and ab6 = 10.00002
Although I have both cells formatted for 0 (zero) decimal places, i.e. they
both show a "10" in the spreadsheet, I wish this comparison to show a "yes"
in its application. Various arithmetic progressions led to the decimal
descrepancy.
How do I correct my "if" comparison to show a "yes" given the above example??
Thanks,
FLKulchar
|