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

 

[Beege]

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