+ Reply to Thread
Results 1 to 2 of 2

I'm stuck on and "function Activities" worksheet its due on MONDAY PLEASE HELP,

  1. #1
    Melissa H via OfficeKB.com
    Guest

    I'm stuck on and "function Activities" worksheet its due on MONDAY PLEASE HELP,

    Ok here's the problem
    If they have a 2005 budget of more than $50,000 have the return:"Largest
    budget for 2005",if they have a 2005 budget between $45,000 and $50,000 have
    the return: "second Largest budget for 2005", if they have a budget between
    $25,000 and $45,000 have the return "third largest budget for 2005", if they
    have a budget between $14,000 and $25,000, have the return:"fourth higest
    budget"; otherwise, the return is "Good job!"
    THIS IS HOW THE WORKSHEE LOOK LIKE I NEED TO ADD A FUNCTION IN THE NEXT COLUM
    PLEASE HELP SOMEBODY AT LEAST WITH ONE PART MY PROBLEM IS I DON'T KNOW HOW TO
    SET THE FORMULA SO THAT THE FUNCTION CAN BE BETWEEN THE NUMBERS PLEASE E-MAIL
    ME ANY INFORMATION THAT YOU MAY HAVE AT [email protected] OR
    [email protected]
    ANY HELP WOULD BE GREAT PLEASE THAT WILL GIVE ME AT LEASE A HEAD START.
    THANX IN ADVANCE

    Budget for 2005 Expenditures for 2005 Budget for 2006
    25000 23000 the budget for 2005 will be the budget for
    2006
    12000 13000 600
    14000 14050 700
    45000 43000 the budget for 2005 will be
    the budget for 2006
    60000 57000 the budget for 2005 will be the budget for
    2006

    --
    Melissa Hilaire

  2. #2
    Forum Contributor
    Join Date
    08-02-2005
    Posts
    102
    Melissa

    =IF(a2>50000,"Largest budget for 2005",if(a2<50000<45000,"Second largest budget for 2005,IF(a2<4500>25000,"Third largest budget for 2005",IF(a2<25000>14000,"Fourth highest budget for 2005,"Good Job"))))

+ 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