Set a cell to blank (Null)

  • Thread starter Thread starter Bill Agee
  • Start date Start date
B

Bill Agee

How can I set a set to Null? I am ussing a formula in a worksheet to pickup
values from another worksheet.

I need to use a formula such as "=IF(ISBLANK(Sheet1!B2), Null,Sheet1!B2)"

If I just say "=Sheet1!B2, then the blank value gets set to 0. I don't want
0, but rather Null.
 
You must log in or register to reply here.

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

How to reference a cell from anther workbook without opening it 0
Save As and new workbook new name used in existing code 8
Excel VBA 1
Help with an IF Formula 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
loop to copy paste 5
Extracting a Part of a Formula as Text 5
CONCATENATE code 2

Back
Top