| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if functions?
Here are some ideas:
a) =CHOOSE(A10-2000,1200,1500,1600........) b)=IF(A11=2006,2000,IF(A11=2007,2000,IF(A11=2008,2 500,0))) come back with specific question best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Struggling of Essex" wrote in message ... I am producing a cashflow. It is over five years, I have established that average contract values for 2006, 2007, 2008 2009 and 2010 will be 800k, 1200k, 2000k, 2500k and 3000k respectively. I want the cell with the contract value to change automatically if a project start date is entered, eg if a project starts in March 2007 its value will be 1200k. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested if functions in Excel 2002 | Excel Worksheet Functions | |||
| limit of 7 nested functions? | Excel Worksheet Functions | |||
| Limited IF Nested Level functions. | Excel Discussion (Misc queries) | |||
| how do I use multiple nested functions? | Excel Worksheet Functions | |||
| ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions | |||
Threaded Mode
