J
JMS
Thank you very much!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MartinW
Hi JMS,
You say that B1=B2,
so if B2 is blank then logically B1 *must* also be blank.
I'm afraid that is about as much sense as I can
make from your post.
Perhaps you might like to try again with more detail.
Regards
Martin
You say that B1=B2,
so if B2 is blank then logically B1 *must* also be blank.
I'm afraid that is about as much sense as I can
make from your post.
Perhaps you might like to try again with more detail.
Regards
Martin
B
Bob Phillips
MartinW said:Hi JMS,
You say that B1=B2,
so if B2 is blank then logically B1 *must* also be blank.
I'm afraid that is about as much sense as I can
make from your post.
Perhaps you might like to try again with more detail.
and some example data
E
excelent
=IF(B2="","",B2)
"JMS" skrev:
"JMS" skrev:
G
Gord Dibben
In B1 enter =IF(B2="","",B2)
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP