excel question?

Question

Since I'm no brainiac on excel I want to ask the following question
1
2
3
4
5
I need a formula that would enable me to get the product of the data in comlumn 1 and either column 2, 3 or 4 depending on which one contains data and get it to appear in column 5.
First clear answer earns 10 points. Many thanks

Answer 1

Ok the easiest way to do this is to type in the following formula in Column 5 (Column E)

=A1*SUM(B1:D1)

This method assumes that only one of Columns 2 to 4 (B, C, D) contain a value but will simply add them together if not prior to the multiplication.

Then simply copy the formula down all rows

I can supply an additional formula which will ONLY take one of Columns 2 to 4 (B, C, D) if a value is present by checking from left to right. Mail me or add a comment if required.

Answer 2

you have to insert the formula into coloumn 5
such as this (1+2+3+4)...it's the formula for SUM. When you have column 5 highlighted then you can do this, you can find it in the insert drop down menu. If you have different columns that are lettered and columns that are numbered the formula has to have the letter and number of what you are trying to do. (A1+B2)- (C3+D4). Just make sure you know what you need in column 5. the sum of all or the difference or a combination.

Answer 3

.
1. Fill in all the data you want calculated in all the columns.
2. Go to the cell in the column you want the sum to appear, and click in it.
3. Click the tool bar Sum button (looks like a backward greek E)
4. Now, drag and highlight all the columns and rows you want to add the data
...You will see the FORMULA appear in the initial you chose, and it will also appear in the fx formula box above.
5. To see the actual sum click off to any other cell to the right or bottom, and the actual sum will appear.

stw
.

Answer 4

1 put C1 in the name box

2in the formula bar (the box with f(x) next to it put the equation;


=A1 * B1


3 copy formula in C1 to the rest of the "C" cells by selecting it and dragging through the of the "C" cells

' 4.Any number placed into any 'A' cell and 'B'cell will coorespond to the result of the multiplication and be placede in the cooresponding 'C' cell.
5

Answer 5

Hi! Here is a simplified formula to get what you need!


=IF(B1<>"", A1*B1, IF(C1<>"", A1*C1, A1*D1))

This formula needs to be placed in cell E1 (column 5). It says, if B1 is NOT NOTHING (so, it has something in it), A1*B1 - otherwise if C1 is not nothing, A1*C1, otherwise A1*D1 (since that is the only option left)

Good Luck!

Jen

Answer 6

Hint use nested if than else. This formula shows you the sum. Modify to produce a product.

Place in Row 1 Column e
=IF(A1>0,SUM(A1:C1),IF(B1>0,SUM(A1:C1), IF(C1>0,SUM(A1:C1),"")))