Blank instead of 0

C

Craig

Sheet2 references Sheet1

Sheet2
A1 = Sheet1!A1

When a Sheet1 cell is blank I would like a blank in Sheet2 instead of a 0

I have tried the following If statement but keep getting errors.

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

Dave Peterson

=if(sheet1!a1="","",sheet1!a1)

Sheet2 references Sheet1

Sheet2
A1 = Sheet1!A1

When a Sheet1 cell is blank I would like a blank in Sheet2 instead of a 0

I have tried the following If statement but keep getting errors.

=IF(Sheet1!A1 isblank, "", Sheet1!A1)
Click to expand...
 

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

Need Help with a VBA subroutine 0
Formula fill series? 1
Copy All Visible Cell Of Sheet1 To Sheet2 Last Blank Row 2
Can you display entire rows that match a certain criteria... 1
how can I copy/paste a formula that skips 27 rows? 0
combo box2 reading a cell like vlookup 0
=Sheet1!A1 - with a blank entry!!! 2
If blank cell 0

Top