Problem with nested If/Or statements in Excel 2007

[dnksideways]

I'm trying to use If/Or statements to get a dashboard to work based on the following criteria and get an error about using too many arguments. I've listed below what I'm trying to get the forumla to produce. When you select the status (shown below) from the list I created in a cell it is supposed to drive the forumula such that:

Status Cell Reference
Green I6
1 Yellow G6
3 Yellow or Red E6
2 Yellow Interpolate between E6 and G6

Here is what I have so far but it's not much:
=IF(OR(K25="Red",K25="3 Yellow"),$E$6,IF(K25="Green",$I$6))

Any help is appreciated and if this isn't clear enough please let me know and I'll provide more information. thanks.

 

[texasalynn]

so I'm not clear
Is there a drop down list? What is the cell reference bit?

 

[dnksideways]

sorry, there is a drop-down list which drives the formula. The user can select "Green", "1 Yellow", "2 Yellow", "3 Yellow", "Red". The formula as listed below is based on the user's selection from the list.
=IF(OR(K25="Red",K25="3 Yellow"),$E$6,IF(K25="Green",$I$6,$G$6))

I know the formula is complete because the last else, the $g$6 reference, doesn't include a selection of 2 Yellow. The 2 Yellow part is what I'm having problems with as it involves linear interpolation between the G6 and E6 values (0 & 5%, respectively).

 

[texasalynn]

ok so I've gotten this setup (I had to hide some columns in order for the HTML to work)

Excel Workbook
	A	B	C	D	E	F	H	I	J	K	L
1	15	Delivered by	Select a year		2010
2			January	February	March	April	June	July	August	September	October
3	1	Boy 7	0	0	0	0	1	0	0	0	0
4	2	Boy 2	0	0	0	0	0	0	0	0	0
5	3	Boy 3	1	0	0	0	0	0	1	0	0
6	4	Boy 22	0	0	0	0	0	0	0	1	0
7	5	Boy 5	0	0	0	0	0	0	0	0	1
Sheet2

Excel 2003

Cell Formulas
Range	Formula
A1	=COUNTIF(Masterlist!D3:D24,E1)
B3	=IF(N($A3),INDEX(Masterlist!$A$3:$G$24,$A3,MATCH(B$1,Masterlist!$A$1:$G$1,0)),"")

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

I setup the drop-down for the year and it seems to work. The formula in A1 is a count for the number of entries that the other formulas work from.

Hopefully this will work for you.