| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ABS <= and logic functions
I'm having trouble with this function
=IF(ABS(G30-F30)<=0.2,"PASS","FAIL") If the numbers in G30 and F30 are bigger than 31 it returs false when equal to 0.2. If I replace the <= with an OR statement it will work for values up to 500. A workaround is to change the criteria to < 0.200000000001 but its not really the same thing. It like some wierd residual significant figures thing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a word in logic functions (instead of a number) | Excel Worksheet Functions | |||
| How do I set two different (AND & OR) logic functions within one | Excel Discussion (Misc queries) | |||
| How do I set two different (AND & OR) logic functions within one | Excel Discussion (Misc queries) | |||
| How do I set two different (AND & OR) logic functions within one | Excel Discussion (Misc queries) | |||
| logic (IF) functions | Excel Worksheet Functions | |||
Threaded Mode
