Formula to ignore blank cells and calculate cells having numbers only

[bodmas]

Hello members,
I am looking for a Formula to calculate cells having numbers only and ignore blank cells. The condition is between two cells, IF there is a value in "A column" then ADDITION should take place or IF there is value in "B column" then SUBTRACTION should take place

Case 1:

Please Login or Register  to view this content.

Case 2:

Please Login or Register  to view this content.

Kindly suggest appropriate formula to the above condition. Thanks!!

[Sam Capricci]

try =IF(AND(A2="",B2=""),"",IF(AND(B2="",A2<>""),C2+A2,C2-B2))
I ignored that you were jumping back and forth between rows and put it all on the same row. You may have to adjust your cells.

[bodmas]

Thanks member @Sambo kid but its not working according to my condition.
Kindly consider these cells C1,A2,B2,C2
In Case I:
If there is any number in A2 and B2 cell is empty then calculate C2=(C1+A2) {Ignoring B2 as blank cell}
Case II:
If A2 cell is empty and B2 cell is having any number then calculate C2=(C1-B2) {Ignoring A2 as blank cell}
Kindly help in excecuting the above condition. Thanks!!

[Sam Capricci]

I did state you might need to repoint the formula, it seems like it will have issues if you try to drag it down.
but here is what I believe you want based on both your posts in C2....
=IF(AND(A2="",B2<>""),C1-B2,IF(AND(B2="",A2<>""),C1+A2,""))