Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is wrong with this formula?
I get the opposite effect when I apply this formula...
=IF(D75=D76,"Balanced","Error") The answer is "Error", even though the amount is exactly the same in D75 and D76. If I reverse it I still get the wrong answer... =IF(D75<D76,"Error","Balanced" The answer is "Balanced" I must be missing some very basic syntax knowledge. The cells D75 and E76 are definitely the same number format. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is wrong in formula. | Excel Discussion (Misc queries) | |||
What is wrong with formula? | Excel Worksheet Functions | |||
Can anyone tell me what's wrong with this formula? | Excel Worksheet Functions | |||
Help please,what is wrong with this formula? | New Users to Excel | |||
What's wrong with this formula? | Excel Worksheet Functions |