| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function confused with 0.1
Hi,
I have set up the following If function to determine if the answer to a simple subtraction of two decimal numbers is 0.1. =IF(C1=0.1,"yes","no") The calculation is merely C1=A1-B1 However, for some calculations it is giving the answer "no" when the answer is clearly 0.1! 1.7-1.6 gives a no response as does 1.4-1.3. Interestingly, from 4.1-4 all answers are no! Hope someone can help Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confused with IF and LOOKUP function | Excel Discussion (Misc queries) | |||
| Very confused.... | Excel Discussion (Misc queries) | |||
| Confused on a function | Excel Worksheet Functions | |||
| confused by COLUMN worksheet function | Excel Discussion (Misc queries) | |||
| Sorry I am confused | Excel Discussion (Misc queries) | |||
Threaded Mode
