Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function needed
Greetings,
I have 7 cells that are"Weighted" as follows Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3 In Cell 8 i need a function that will add the weight of each cell and muliply by the value of each cell for example if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i should also mention that not all 7 cells will have a value but atleat one will, Can this be done in a function or should i do it programmaticlly? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function needed
if
cell1 is A1 cell2 is A2 cell3 is A3 cell4 is A4 cell5 is A5 cell6 is A6 cell7 is A7 then in A8 enter: =A1+2*A2+3*A3+2*A4+3*A5+2*A6+3*A7 -- Gary''s Student - gsnu200791 "Office_Novice" wrote: Greetings, I have 7 cells that are"Weighted" as follows Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3 In Cell 8 i need a function that will add the weight of each cell and muliply by the value of each cell for example if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i should also mention that not all 7 cells will have a value but atleat one will, Can this be done in a function or should i do it programmaticlly? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function needed
Thank you.
"Gary''s Student" wrote: if cell1 is A1 cell2 is A2 cell3 is A3 cell4 is A4 cell5 is A5 cell6 is A6 cell7 is A7 then in A8 enter: =A1+2*A2+3*A3+2*A4+3*A5+2*A6+3*A7 -- Gary''s Student - gsnu200791 "Office_Novice" wrote: Greetings, I have 7 cells that are"Weighted" as follows Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3 In Cell 8 i need a function that will add the weight of each cell and muliply by the value of each cell for example if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i should also mention that not all 7 cells will have a value but atleat one will, Can this be done in a function or should i do it programmaticlly? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function needed
Would this work?
=SUMPRODUCT(A1:A7,{1;2;3;2;3;2;3}) (=13) -- HTH :) Dana DeLouis "Office_Novice" wrote in message ... Greetings, I have 7 cells that are"Weighted" as follows Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3 In Cell 8 i need a function that will add the weight of each cell and muliply by the value of each cell for example if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i should also mention that not all 7 cells will have a value but atleat one will, Can this be done in a function or should i do it programmaticlly? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function needed
A slightly easier way especially if there will be many cells
=SUMPRODUCT(A1:A7,{1;2;3;2;3;2;3}) -- Regards, Peo Sjoblom "Office_Novice" wrote in message ... Thank you. "Gary''s Student" wrote: if cell1 is A1 cell2 is A2 cell3 is A3 cell4 is A4 cell5 is A5 cell6 is A6 cell7 is A7 then in A8 enter: =A1+2*A2+3*A3+2*A4+3*A5+2*A6+3*A7 -- Gary''s Student - gsnu200791 "Office_Novice" wrote: Greetings, I have 7 cells that are"Weighted" as follows Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3 In Cell 8 i need a function that will add the weight of each cell and muliply by the value of each cell for example if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i should also mention that not all 7 cells will have a value but atleat one will, Can this be done in a function or should i do it programmaticlly? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function needed
Oops! Just posted the same solution, I somehow missed your post Dana
-- Regards, Peo Sjoblom "Dana DeLouis" wrote in message ... Would this work? =SUMPRODUCT(A1:A7,{1;2;3;2;3;2;3}) (=13) -- HTH :) Dana DeLouis "Office_Novice" wrote in message ... Greetings, I have 7 cells that are"Weighted" as follows Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3 In Cell 8 i need a function that will add the weight of each cell and muliply by the value of each cell for example if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i should also mention that not all 7 cells will have a value but atleat one will, Can this be done in a function or should i do it programmaticlly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Function Needed | Excel Worksheet Functions | |||
help needed in worksheet function | Excel Worksheet Functions | |||
Needed: worksheet export help | Excel Discussion (Misc queries) | |||
IF, AND, OR Function help needed | Excel Worksheet Functions | |||
Function needed???? | Excel Worksheet Functions |