# Thread: Making a Budget Report with IF & And Functions

1. ## Making a Budget Report with IF & And Functions

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!

2. Try

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•