How do you exclude cells from still returning a value when the first cell in the equation has no data.
The object is to be able to fill data along a date column that is compared to a fixed cell, i.e. $A$1 But not for all cells that are along the date column to return a value.
B 1 is 100 A1 is 90 C1 =B1-A1= 10
B2 is 90 A1 is 90 C2 =B2-A1=0
B3 is blank A1 is 90 C3 Blank
Is it possible to have a formula in one cell that can take information from one of two cells, using whichever one has data, and then using a formula based on which one it was taken from.
I.e. $A$1 has data Cell C1 uses a formula to Subtract.
$B$1 has data Cell C1 uses a formula to add
Both A1 and B1 has Data Cell C1 returns the plus/minus difference.
I am new to excel and really could do with some help as my background is not in computing so if you would like to become a personnel trainer in it then I would be most greatfull. My Email is email@example.com and my name is dave. Have a good day either way