Function to not display until data entered

T

tml41dmb

I'm setting up a profit spreadsheet with actual and quota figures. What
function do I use so that each month I can input the data and the function
will display everything else, without displaying wrong #s in the meantime.
ie...Just leave YTD function cell blank until 2006 March's Actual has been
put in. Sorry for the horrible wording, it's my 1st time posting on here.
Thanks.
 
B

Bernard Liengme

Not much to work with but it look like you need something like
=IF(some_cell_>0, formula,"")
best wishes
 
Top