Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet VBA function - not recognized | Excel Worksheet Functions | |||
changing font style in a complex worksheet function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Worksheet Function - Find? | Excel Worksheet Functions |