Boards
Excel question, advanced
IF functions, they're the fucking shit aren't they? I get a massive hard on from them, but I'm having a recurring problem.
=IF(E14="",0,E5-E14)
I want my cell to show 0 if E14 is blank, but show the difference between E5 and E14 if not. I'm massively confident that I've got the formula right, but...
Lets say E5=100. If I enter 100 into E14, rather than showing "0" it shows "0.32" or something similar. WHY GOD DAMN YOU?!