B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
 

Thank you very much!

B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
 

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


"JMS" wrote in message
...
Thank you very much!

B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
 

"MartinW" wrote in message
...
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

B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
 

=IF(B2="","",B2)


"JMS" skrev:

Thank you very much!

B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
 

In B1 enter =IF(B2="","",B2)


Gord Dibben MS Excel MVP

On Fri, 2 Nov 2007 23:59:00 -0700, JMS wrote:

Thank you very much!