This is a simplified version of what I have in MySQL that I'm struggling to turn into a formula:
What I have so far is this (and I know I still need to add the 2nd line in):
It's marking everything as Under Budget, which shouldn't be the case. Can someone identify what I've done wrong?
Thanks!
SQL:
IF C2 < B2 * 1.01 AND C2 - B2 > 20000 then "Over Budget"
IF C2 > B2 * 1.01 AND C2 - B2 > 5000 then "Over Budget"
else "Under Budget"
What I have so far is this (and I know I still need to add the 2nd line in):
Excel Formula:
=IF(AND(C2<=(B2*1.01),C2-B2>=20000),"Over Budget","Under Budget")
It's marking everything as Under Budget, which shouldn't be the case. Can someone identify what I've done wrong?
Thanks!