If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to calcuate 6 variable's contribution towards a fixed sum???
I have a number of stats on hand. In column A is the results of column B, C,
D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve sometimes -'ve) Is there a function that can tell me the relations between value A vs B, A vs C, A vs D... etc) Your help can save my job~ Thanks |
#2
|
|||
|
|||
How to calcuate 6 variable's contribution towards a fixed sum???
=IF(AND(A1=B1,A1=C1,A1=D1,A1=E1,A1=F1,A1=G1))
-- Regards Dave Hawley www.ozgrid.com "Alexander" wrote in message ... I have a number of stats on hand. In column A is the results of column B, C, D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve sometimes -'ve) Is there a function that can tell me the relations between value A vs B, A vs C, A vs D... etc) Your help can save my job~ Thanks |
#3
|
|||
|
|||
How to calcuate 6 variable's contribution towards a fixed sum???
Hi,
May be this =COUNTIF(B1:G1,A1)=6 or even =IF(COUNTIF(B1:G1,A1)=6,"Do this for true","Or this for false") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Alexander" wrote: I have a number of stats on hand. In column A is the results of column B, C, D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve sometimes -'ve) Is there a function that can tell me the relations between value A vs B, A vs C, A vs D... etc) Your help can save my job~ Thanks |
Thread Tools | |
Display Modes | |
|
|