Results 1 to 2 of 2

Thread: Making a Budget Report with IF & And Functions

  1. #1

    Making a Budget Report with IF & And Functions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #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
  •