Formula Help pleaseee URGENT!!!!

[Yossy]

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

 

[ND Pard]

Try this nested if statement:

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

Good Luck.

 

[Peo Sjoblom]

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]

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.

 

[Yossy]

you mean less people like you

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