Do not sum until cell has a value

T

Todd Fleming

This has go to be easy but I can seem to find any help on it.

I have a value in cell A, a blank in cell B (to be filled later with a
less than or equal to value of cell A), and a subtraction formula of
cell B from cell A in cell C.

I would like the cell C to show nothing until a value is put in cell B.
 
M

MSJ

This has go to be easy but I can seem to find any help on it.

I have a value in cell A, a blank in cell B (to be filled later with a
less than or equal to value of cell A), and a subtraction formula of
cell B from cell A in cell C.

I would like the cell C to show nothing until a value is put in cell B.
Click to expand...


I believe this is what you are looking for.


=IF(ISBLANK(B1),"",B1-A1)
 
Top