| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Too many arguements?
I have a formula I'm trying to get to work. Here is what I have so far (it
doesn't work yet): =IF(C39=0,"",IF(R39=V,IF(AR39<=0,"Y",IF(AR39=0,"N ")),IF(AA39<=0,"Y",IF(AA39=1,"N")))) I need the formula to look at column C first. If it's a 0 then display nothing in column Q (where this formula is placed). If there's a 1 in column C, I need the formula to look at column R for either a V or an R. If it's a V do this function: R39=V,IF(AR39<=0,"Y",IF(AR39=0,"N" If it's an R, do this function: IF(AA39<=0,"Y",IF(AA39=1,"N" Any help would be great! Thanks. -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested IF - too many arguements. | Excel Worksheet Functions | |||
| how can i have more than 30 arguements in a SUM | Excel Discussion (Misc queries) | |||
| Too many arguements | Excel Discussion (Misc queries) | |||
| Formula using IF, AND and OR Arguements | Excel Worksheet Functions | |||
| NPV calc with more than 29 arguements? | Excel Worksheet Functions | |||
Threaded Mode
