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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Comparison of columns using Conditional Formatting 3
SUM Char 9
value is "0" 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
calculating a value if adjacent cell has value 3
Image not displaying in datagridview column in vb.net 1
Excel Typed text appears in wrong cell 0

Top