| 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) | |||
Hybrid Mode
