Excel

C

Chip Pearson

Jay,

Write your formula like the following:

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

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

Excel Named Ranges and Conditional Format 3
Excel formula, sum the value cell and if empty cell left blank 0
Displaying zeros in cells 2
Default number format in Excel 1
Excel Unlink open excel files 2
Works to Excel Conversion Bug 2
Alert Errors need to be either Blank or "$0.00" 5
When Scrolling Cells Sometimes Appear Blank but are not 5

Top