Hi,
Here is the formula I am currently using trying to accomplish the goal detailed below:
=AND(IF(AND(F1161>=0,F1161<(0.8*F1125)),"In Budget","Error"),IF(AND(F1161>=(0.8*F1125),F1161<(F1125)),"Near Budget","Error"),IF(AND(F1161>=F1125),"Over Budget","Error"))
Goal:
If cell value is between 0 - 80 then it is "In Budget"
If cell value is between 80 - 100 then it is "Near Budget"
If cell value is over 100 then it is "Over Budget"
The numbers listed in the Goal are arbitrary as they really are a percentage of a specific cell. The specific cell is an accumulated numeric value of expenses.
Let me know what I need to change to the formula in order to accomplish this goal?
Thanks!
Here is the formula I am currently using trying to accomplish the goal detailed below:
=AND(IF(AND(F1161>=0,F1161<(0.8*F1125)),"In Budget","Error"),IF(AND(F1161>=(0.8*F1125),F1161<(F1125)),"Near Budget","Error"),IF(AND(F1161>=F1125),"Over Budget","Error"))
Goal:
If cell value is between 0 - 80 then it is "In Budget"
If cell value is between 80 - 100 then it is "Near Budget"
If cell value is over 100 then it is "Over Budget"
The numbers listed in the Goal are arbitrary as they really are a percentage of a specific cell. The specific cell is an accumulated numeric value of expenses.
Let me know what I need to change to the formula in order to accomplish this goal?
Thanks!