Do not sum until cell has a value
 

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.

Do not sum until cell has a value
 

=IF(B1="","",A1-B1)
--
David Biddulph

"Todd Fleming" wrote in message
...
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.

Do not sum until cell has a value
 

One way...

=IF(COUNT(A1:B1)<2,"",B1-A1)

--
Biff
Microsoft Excel MVP


"Todd Fleming" wrote in message
...
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.

Do not sum until cell has a value
 

On Sep 18, 2:13*pm, Todd Fleming wrote:
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.


I believe this is what you are looking for.


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

Do not sum until cell has a value
 

On Sep 18, 2:20*pm, MSJ wrote:
On Sep 18, 2:13*pm, Todd Fleming wrote:

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.

I believe this is what you are looking for.

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

Ahh. I knew there were probably more than one answer. Thank you.