I can't wait to see the Excel 2007 version of 64 nested IF's!

Biff

"Don Guillett" wrote in message
...
A more detailed explanation might help

--
Don Guillett
SalesAid Software

"driller" wrote in message
...
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 ?