Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default 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 ?
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 341
Default Will 7 IFs remain ?

Why don't you think it would work?
1) seven ifs work
2) sumproduct works
so why shouldn't they work together?

question is, can you make them work together?
--
Allllen


"driller" wrote:

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 ?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default Will 7 IFs remain ?

thanks for reply with a hard question...I thought you can help me solve this
question ?
It look like "sumproduct" is a longer word than IF"...anyway...

in common english simple term = sumproduct is the sum of product.

Maybe its better to put a standard excel suffix, hear like sumproductif -
same with the rest countif, sumif...to avoid the common denominators
perception of a very poor english formula name will provide a correct result.
Ain't it?



"Allllen" wrote:

Why don't you think it would work?
1) seven ifs work
2) sumproduct works
so why shouldn't they work together?

question is, can you make them work together?
--
Allllen


"driller" wrote:

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 ?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default Will 7 IFs remain ?

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 ?







  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default Will 7 IFs remain ?

ooops. almost forgot, How many logical criteria's available on sumproduct ?
I cant see it in excel 2003 help, i just see arrays I cant find any
logical_test criterias. Can we see this in next upgrade ?

"Allllen" wrote:

Why don't you think it would work?
1) seven ifs work
2) sumproduct works
so why shouldn't they work together?

question is, can you make them work together?
--
Allllen


"driller" wrote:

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 ?

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default Will 7 IFs remain ?

What are you talking about?
--
Brevity is the soul of wit.


"driller" wrote:

thanks for reply with a hard question...I thought you can help me solve this
question ?
It look like "sumproduct" is a longer word than IF"...anyway...

in common english simple term = sumproduct is the sum of product.

Maybe its better to put a standard excel suffix, hear like sumproductif -
same with the rest countif, sumif...to avoid the common denominators
perception of a very poor english formula name will provide a correct result.
Ain't it?



"Allllen" wrote:

Why don't you think it would work?
1) seven ifs work
2) sumproduct works
so why shouldn't they work together?

question is, can you make them work together?
--
Allllen


"driller" wrote:

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 ?

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default Will 7 IFs remain ?

its english Dave, I click Fx button, choose sumproduct function, pop-up form
appears for sumproduct "tarannnn " you can see the form box instruction -
excel standard way -arrays-. out of that, how to assure ?

"Dave F" wrote:

What are you talking about?
--
Brevity is the soul of wit.


"driller" wrote:

thanks for reply with a hard question...I thought you can help me solve this
question ?
It look like "sumproduct" is a longer word than IF"...anyway...

in common english simple term = sumproduct is the sum of product.

Maybe its better to put a standard excel suffix, hear like sumproductif -
same with the rest countif, sumif...to avoid the common denominators
perception of a very poor english formula name will provide a correct result.
Ain't it?



"Allllen" wrote:

Why don't you think it would work?
1) seven ifs work
2) sumproduct works
so why shouldn't they work together?

question is, can you make them work together?
--
Allllen


"driller" wrote:

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 ?

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default Will 7 IFs remain ?

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 ?




  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default Will 7 IFs remain ?

thanks for reply Don,
excel standard function that i can pull down from fx button
1. SUM
2.SUMIF
3.COUNT
4.COUNTIF
5.SUMPRODUCT
6. could be Sumproductif - If you dont mind ? hope no problem with your work.

"Don Guillett" wrote:


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 ?






  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default Will 7 IFs remain ?

6. could be Sumproductif

And what would Sumproductif do?

Sumproduct already works on implied IF logic:

=SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y"))

IF A1:A10 equals "x" AND IF B1:B10 = "y" SUM the instances where BOTH
conditions are TRUE.

Biff

"driller" wrote in message
...
thanks for reply Don,
excel standard function that i can pull down from fx button
1. SUM
2.SUMIF
3.COUNT
4.COUNTIF
5.SUMPRODUCT
6. could be Sumproductif - If you dont mind ? hope no problem with your
work.

"Don Guillett" wrote:


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 ?








  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default Will 7 IFs remain ?

What it can do? maybe more than we expect....with english language integrity.
Lets hope for LCD's approach be well considered. Maybe next upgrades will
not be in question- help files, support files, a lot of historically
established function integrity. we're not alone in microsoft kingdom. Ain't
it?

"Biff" wrote:

6. could be Sumproductif


And what would Sumproductif do?

Sumproduct already works on implied IF logic:

=SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y"))

IF A1:A10 equals "x" AND IF B1:B10 = "y" SUM the instances where BOTH
conditions are TRUE.

Biff

"driller" wrote in message
...
thanks for reply Don,
excel standard function that i can pull down from fx button
1. SUM
2.SUMIF
3.COUNT
4.COUNTIF
5.SUMPRODUCT
6. could be Sumproductif - If you dont mind ? hope no problem with your
work.

"Don Guillett" wrote:


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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Online worksheet and remain sortable? guyfromage Excel Discussion (Misc queries) 2 October 13th 06 01:04 PM
Can a copy of a chart remain "live" SouthAfricanStan Charts and Charting in Excel 1 October 13th 06 03:11 AM
How do I get word wrap format to remain in an Excel pivot table? KSchmidt Excel Discussion (Misc queries) 3 October 12th 06 10:39 PM
remain constant in a copy & paste Viviank New Users to Excel 5 March 18th 06 11:33 PM
NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? san Excel Discussion (Misc queries) 2 September 2nd 05 05:47 PM


All times are GMT +1. The time now is 12:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"