Thread
:
Will 7 IFs remain ?
View Single Post
#
10
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Will 7 IFs remain ?
how about the existing ARRAY formula
=Sum(if
adapted to your needs? You have been asked repeatedly to furnish complete
details about what you are trying to do............................... There
may be an easier way.
--
Don Guillett
SalesAid Software
"driller" wrote in message
...
Hi Don,
maybe u can help us reach MS excel to introduce a function called
SUMPRODUCTIF...at least to assure that we can have an Fx formbox over
excel
standard and backup by helpfiles..Do you agree?
"Don Guillett" wrote:
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 ?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett