=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what am
doing wrong. Please help. Thanks.

if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

Try this nested if statement:

=If(B3=0,C3,If(B3=C3,B3&" "&C3,B3))

Good Luck.

"Yossy" wrote:

=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what am
doing wrong. Please help. Thanks.

if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

First of all remove "URGENT" from future posts, the only thing it will
achieve is probably getting less people
interested to help you

=IF(B3=C3,B3&" "&C3,IF(B3=0,C3,B3))



--


Regards,


Peo Sjoblom





"Yossy" wrote in message
...
=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what
am
doing wrong. Please help. Thanks.

if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

Thanks so very much ND Pard. works great. I realized using your formula that
i wanted a different result. Your formula gave me a very good lead.
=IF(B2=0,C2,IF(B2=C2,B2, B2&" "&C2)) so I just adjusted it. Thanks again for
quick response. I really appreciate it.

"ND Pard" wrote:

Try this nested if statement:

=If(B3=0,C3,If(B3=C3,B3&" "&C3,B3))

Good Luck.

"Yossy" wrote:

=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what am
doing wrong. Please help. Thanks.

if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

you mean less people like you

"Peo Sjoblom" wrote:

First of all remove "URGENT" from future posts, the only thing it will
achieve is probably getting less people
interested to help you

=IF(B3=C3,B3&" "&C3,IF(B3=0,C3,B3))



--


Regards,


Peo Sjoblom





"Yossy" wrote in message
...
=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what
am
doing wrong. Please help. Thanks.

if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

URGENT -

Your post won't be answered any quicker than a post that doesn't have
URGENT in the subject line. It just shows rudeness or a visage of
self-importance. I'm sure it was urgent, but the real experts here will
take the time to respond no matter what (kudos to those experts). It's
just polite to leave it out.

Beege

Yossy wrote:
you mean less people like you

"Peo Sjoblom" wrote:

First of all remove "URGENT" from future posts, the only thing it will
achieve is probably getting less people
interested to help you

=IF(B3=C3,B3&" "&C3,IF(B3=0,C3,B3))



--


Regards,


Peo Sjoblom





"Yossy" wrote in message
...
=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what
am
doing wrong. Please help. Thanks.

if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.