View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ND Pard ND Pard is offline
external usenet poster
 
Posts: 73
Default Formula Help pleaseee URGENT!!!!

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.