| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will 7 IFs remain ?
I donot know yet until now if it is possible to have an excel standard 7 IFs
formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Online worksheet and remain sortable? | Excel Discussion (Misc queries) | |||
| Can a copy of a chart remain "live" | Charts and Charting in Excel | |||
| How do I get word wrap format to remain in an Excel pivot table? | Excel Discussion (Misc queries) | |||
| remain constant in a copy & paste | New Users to Excel | |||
| NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? | Excel Discussion (Misc queries) | |||
Threaded Mode
