When 1 sheet = a blank date field on another tab the result = 0-Ja

K

Karen Ramel

Using Excel 2003

How do I please get the result of the 'formula' to show BLANK when no date
is entered in the source field?

When a date IS entered in the source the display/value shown is fine.

Please advise
 
G

Gord Dibben

=IF(A1="","",A1)

Or a cross-sheet linking formula

=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 08:55:01 -0700, Karen Ramel <Karen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher is filling blank lines with data 2
Autonumber field in Excel that behaves the same as Access 0
Get the right language when inserting a date 2
result should equal a blank field 2
display date of today in cell X when number >0 in cell Y 2
Conditional Formatting Less Than Today Week Days only 0
Have the SUMIF result (formula) on a separate sheet/tab 2
How To Have A Cell Be Blank If... 2

Top