Function to not display until data entered
 

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.

Function to not display until data entered
 

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.

Function to not display until data entered
 

You can change your formula to create a null string.

=IF(A5="","",myfunction(arguments))

If you are into macros, you could use a Change Event macro to create the formula and insert the date.
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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.