View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default 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