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 OR

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

Melissa

Something along the lines of the following

If(a250000,"Largest etc", IF(a2<5000045000,"Second largest etc",
IF(A2<4500025000,"Third largest etc", IF(A2<2500014000,"Fourth
largest etc","Good Job!))))

You might need to experiment with this a bit, but it should work


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=401477

Melissa

=IF(a250000,"Largest budget for 2005",if(a2<50000<45000,"Second
largest budget for 2005,IF(a2<450025000,"Third largest budget for
2005",IF(a2<2500014000,"Fourth highest budget for 2005,"Good Job"))))


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=428865