Required Formula using IF condition to find text in a column and depending on th

Question

Required Formula using IF condition to find text in a column and depending on that do some addition and subtraction in the required column

Hi,

I have data something like below table

You can see the Column A has text in cells and 2 cells are empty. I want a excel formula which works like below

IF Column A has text in a cell then add the corresponding values in the same row for example A1 has text Adam in it so B1 should be add to C1.

IF Column A has no text in the cell like A2 then B2 should be subtracted from C2.

Required Formula using IF condition to find text in a column and depending on that do some addition and subtraction in the required column Hi, I have data something like below table You can see the Column A has text in cells and 2 cells are empty. I want a excel formula which works like below IF Column A has text in a cell then add the corresponding values in the same row for example A1 has text Adam in it so B1 should be add to C1. IF Column A has no text in the cell like A2 then B2 should be subtracted from C2.

Explanation / Answer

=if(A1<>"",B1+C1,B1-C1)

copy formula down, if this is not what you are looking for please post the results required

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.