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.
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.