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
SET THE FORMULA SO THAT THE FUNCTION CAN BE BETWEEN THE NUMBERS PLEASE E-MAIL
ME ANY INFORMATION THAT YOU MAY HAVE AT melissah1216@aol.com OR
melissahilaire2006@yahoo.com
ANY HELP WOULD BE GREAT PLEASE THAT WILL GIVE ME AT LEASE A HEAD START.

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. 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"))))

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

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