| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any number above 15 returns false when it should be true
=IF((16.99-16)=0.99,10,0)
In this function, any number from (1.99-1) through (15.99-15) works and any number above (16.99-16) fails. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Any number above 15 returns false when it should be true
It's because the underlying value is not 0.99, it's in fact
0.989999999999998 You could remedy this in your case by using this =IF(ROUND(16.99-16,2)=0.99,10,0) that's the way computer works, see these links for an explanation http://www.mcgimpsey.com/excel/pennyoff.html http://www.cpearson.com/excel/rounding.htm -- Regards, Peo Sjoblom "tlaurie777" wrote in message ... =IF((16.99-16)=0.99,10,0) In this function, any number from (1.99-1) through (15.99-15) works and any number above (16.99-16) fails. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Any number above 15 returns false when it should be true
try
IF(ROUND(16.99-16,2)=0.99,10,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "tlaurie777" wrote in message ... =IF((16.99-16)=0.99,10,0) In this function, any number from (1.99-1) through (15.99-15) works and any number above (16.99-16) fails. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| First part of "IF" function returns false even if true. ?? | Excel Worksheet Functions | |||
| Convert TRUE/FALSE results to a number | Excel Worksheet Functions | |||
Hybrid Mode
