Not much to work with but it look like you need something like
=IF(some_cell_0, formula,"")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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