The task is this:
I have a numerical value in cell B1, then I have another numerical value in B2. If I have marked an X in cell A2, then and only then should the values B1 and B2 be added.
Otherwise I do not want these values to be added automatically. Please Please help me if you know the solution for this!! Thanks!!!
2007-03-19 16:11:55 · 8 answers · asked by sassy 1 in Computers & Internet ➔ Software
If you want the total of B1 and B2 in cell C2 then the formula to put in C2 is "=IF(A2="X",B1+B2,0)" but without the quotes.
2007-03-19 16:20:30 · answer #1 · answered by Peter F 2 · 1⤊ 0⤋
I think this is what you mean...
I've set up the following across 4 columns
A B C D
1 3 X 4
2 4
D is my result column that adds columns A and B if the value X is in C, otherwise it leaves an empty cell.
Here is the formula I used:
=IF(UPPER(C1="X"),A1+B1,"")
Note: You can change the empty string ("") to zero, or anything else you like.
2007-03-19 16:32:08 · answer #2 · answered by roconjuai 1 · 1⤊ 0⤋
Enter this formula in the cell where you want the results brom cells b1 and b2 being added together.
=IF(A1="x",B1+B2,0)
If X is not in cell a1, then the result will be zero.
Keep in mind the relative vs absolute cell reference. Hope this helps!
2007-03-19 16:24:33 · answer #3 · answered by treadmillchallenge 1 · 1⤊ 0⤋
=if(isblank(a2)=true," ",b1+b2)
Put this in the cell where you want the answer to B1 + B2 to appear.
2007-03-19 16:16:46 · answer #4 · answered by ? 2 · 1⤊ 0⤋
in case you want subtotals of communities, use the grouping and sub totals valuable factors. their particular applications that upload the precis row assistance. If its something else, you should must have VBA programming to apply the locate textual content subroutine, get the take care of, and then use the offset with assistance from a million row to get the cellular below, finally you;d set the formulation for the offset cellular.
2016-11-26 23:52:34 · answer #5 · answered by Anonymous · 0⤊ 0⤋
I do believe this is the correct function in your equation use the control key to select the cells that you want and then press enter and yo ushould be set.
2007-03-19 16:17:28 · answer #6 · answered by Mike 3 · 0⤊ 1⤋
=IF(A2="X",SUM(B1:B2),"")
If there is not an X in A2 it will return a blank in the cell.
put this formula anywhere
2007-03-19 16:16:10 · answer #7 · answered by There you are∫ 6 · 3⤊ 0⤋
Highlight the blocks you need, then cut and then paste it to the one new block! I hope that helps you out. If you need more help, you can get tips on the Microsoft Website.!
2007-03-19 16:16:46 · answer #8 · answered by Jersey Girl 2 · 0⤊ 1⤋