i Kara, this should work:
=if(typeindata!h13="","",typeindata!h13)
HTH.
Kevin
-----Original Message-----
I have two spreadsheets set-up. Sheet 1 is TypeInData
and Sheet 2 is
SaveCSV_file. On TypeInData I have a column that is
formatted to show dates
in the dd-mmm-yy format. When I go to SaveCSV_file and
enter the formula
=TypeInData!H13 it will enter 0-Jan-00 if nothing is
entered into H13. How
can I make that field blank if nothing is typed into H13
on the TypeInData
spreadsheet?
I have tried an IF statement, an IF statement with
ISBLANK, an IF statement
with ISText and I cannot seem to get any of them to work.
Thanks for your help!
Kara
.
|