+ Reply to Thread
Results 1 to 9 of 9

IF function to define over budget or under budget

Hybrid View

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Please help with the "if" function

    I have manually put in the over and under without using the functions but I need to know how to use the function;

  2. #2
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Please help with the "if" function

    Good morning mrose,
    IF functions are actually quite easy to use (though they can definitely get tricky!). As a basic introduction, IF functions have 3 criteria, the first being what you are testing for (So if A1 has a drop down that has both 1 and 2 as an option and you want B1 to say "yes" if A1 has a 1 in it, or "no" if A1 does not have a 1, you would put it as =IF(A1="1", "yes', "no"). The second criteria (after the first comma, or A1="1",) is the value you want to return if the first criteria is met. The third criteria is what you want it to return if the first criteria isn't met.

    So, with your specific example, you will want to do =IF("total monthly amount> total monthly budget", "over","under").

  3. #3
    Registered User
    Join Date
    06-15-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Please help with the "if" function

    thank you for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1