Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to populate Label1.Caption with a variable's value | Excel Discussion (Misc queries) | |||
NPV of cashflows to assess contribution to a joint venture | Excel Worksheet Functions | |||
Return the Row of a Variable's location | Excel Discussion (Misc queries) | |||
Percent Contribution | Excel Discussion (Misc queries) | |||
How to calculate pension contribution on salary? | Excel Discussion (Misc queries) |