| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula doesn't work with certain numbers
I have 2 columns, both summed. If the sums equal, the 3rd column is to say
"ok". If they don't, it says "check bal". We have been doing this for months. Today I entered "197.14" in both columns. The sum total is the same. The IF column says "check bal". I can put in "197" and it works, "197.12" works, "197.13" & "197.15" work. "197.10" also doesn't work. We finally added 197.14 to a total in another cell & it worked fine. We reformatted & made sure everything was numbers & that there was no rounding in the total numbers. Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| IF formula - evaluation shows it should work but... | Excel Worksheet Functions | |||
| Auto Extend Formulas doesn't work for a particular formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Threaded Mode
