Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming |