Forum Discussion
Formula Required: Outside of a range (plus or minus)
I had this formula =IF(S3=R3,"Good",IF(ABS(S3-R3)<=20%,"Under","Over")) But I want to check the values are within an allowable range. So it's whether I can combine something like this to a single...
In the attached file, the formula in C2 is:
=IF(ABS(A2-B2)<=0.2,"Good",
IF(A2-B2>0.2,"Over Budget",
"Under Budget"))
Given that expenditures are cash outflows, let me accentuate that an "Under Budget" is a favorable variance, such that you spent less than you should and you must strive to spend lesser. Conversely, an "Over Budget" is an unfavorable variance, such that you spent more than you should and you must strive to spend less next time.
In the attached file, the formula in C2 is:
=IF(ABS(A2-B2)<=0.2,"Good",
IF(A2-B2>0.2,"Over Budget",
"Under Budget"))
Given that expenditures are cash outflows, let me accentuate that an "Under Budget" is a favorable variance, such that you spent less than you should and you must strive to spend lesser. Conversely, an "Over Budget" is an unfavorable variance, such that you spent more than you should and you must strive to spend less next time.