Make cells with formula apppear blank

[cdpaul]

Hi,
I have a made a number of spreadsheets which have a sub-totals formula for corresponding cells. The formula for example "=IF(C3>0,C3-B3,-B3)".
If I insert the formula in D3 and drag it down to D50 (or any number) all the D cells show £0.00. Can I make an addition to the formula that will NOT show a value until cells C and B are given a value?

I hope I've explained it properly

Thanks in advance

 

[MARK858]

Possibly

=IF(OR(C3="",B3=""),"",IF(C3>0,C3-B3,-B3))

 

[Chrisdontm]

Try this in cell " D3 "


=IF(OR(B3="",C3=""),"",IF(C3>0,C3-B3,-B3))

 

[cdpaul]

Fab, thank you gents

 

[cdpaul]

Further to this may I ask one other thing?

As I said I add the formula into the cell then drag it down to however many cells, but is there a way to make the formula continue throughout the whole column?

Thanks

 

[MARK858]

but is there a way to make the formula continue throughout the whole column?

Never a good idea to fill formulas to an entire column.

If you have data in the one of the columns on either side of the formula then if you double-click the bottom right hand corner of the formulas cell it will autofill until the adjacent column has a blank cell.

 

[cdpaul]

Thanks again