Making a Budget Report with IF & And Functions

w329

New member
Joined
Apr 6, 2014
Messages
1
Reaction score
0
Points
0
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!
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=IF(AND(F41>=0,F41<=80),"In Budget",IF(F41<=100,"Near Budget",IF(F4>100,"Over Budget","Error")))
 
Top