| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error nesting IF function
In A1 I have a formula that can have 7 results: a,b,c,d,e,f,g In range A65:A95 I have the results I want if "a", B65:B95 results if "b" and so on. What I want is if A1=a, then A2:A32 will fill up w/ the range from A65:A95 What I came up w/ for cell A2 was =IF(A1="a",A65),IF(A1="b",B65),IF(A1="c",C65),IF(A 1="d",D65),IF(A1="e",E65),IF(A1="f",F65),IF(A1="g" ,A65) I'm getting a #VALUE! error. What am I doing wrong or is there a better way to do this? Thanks, -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540116 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
