Forum Discussion
Excel - How do I compare calculated values in cells with the IF function?
In Excel 2010 I have two cells that contain formulas, A1 and A2. A1=5-4 B1=3-2 Both return and display the same calculated value = 1 But if I place this formula in another cell =A...
Couldn't replicate your problem. Have look at the attached workbook. Works for me as it should. Does it work for you?
I made a copy of the Excel 2010 financial workbook from the Win 7 machine and opened it with Excel 2013 on the Win 10 machine.
Same problem! So it isn't the version of Excel that is the problem, or the OS or machine architecture.
The plot thickens ....
Phil