Forum Discussion

Copper Contributor

Apr 09, 2018

Solved

$137.96 causes IF THEN formula to fail. I'm not making this up.

I created a spreadsheet on my MacBook (OSX 10.13.3), running Excel for Mac 2011 (v14.7.7 (170905)) to track business expenses for tax purposes. See attached. I've got 4 categories of expenses, Supp...

Excel Conundrum.xlsx61 KB

excel

Excel on Mac

Formulas and Functions

Detlef_Lewin
Apr 09, 2018
Hi

A more entertaining answer:
https://www.youtube.com/watch?v=PZRI1IfStY0

Detlef_Lewin

Silver Contributor

Apr 09, 2018

A more entertaining answer:

https://www.youtube.com/watch?v=PZRI1IfStY0

tfears1
Copper Contributor
Apr 11, 2018
Consider my world rocked. Math used to be a pure science to me. Now I have nothing to live for any more. Curse you, cruel world of floating point numbers unreality!