Do not sum until cell has a value

  • Thread starter Thread starter Todd Fleming
  • Start date Start date
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.
 
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)
 
Back
Top