Multiple IF statements

[dipsydoodle]

Excel help.JPG

Hello,

Hopefully my image has attached properly, I'm struggling to get the display in the format that I need it in. I need the & or and in the middle.

I've been trying for ages and I have gotten myself confused (hence I am here)

Basically I need:
If A2 is blank, then leave it blank, if not display A2....and....IF B2 is blank, then leave it blank if not display A2...(but I need to take into consideration the scenario that A or B are blank and therefore I don't need the & symbol.

If there a "simple" way to get this?

Thank you in advance

[Roel Jongman]

Try:

Please Login or Register  to view this content.

[javaid]

Hi,
Try this formula,
=IF(AND(D1>0,E1>0),D1&" & "&E1,IF(AND(D1>0,E1=0),D1,IF(AND(D1=0,E1>0),E1,"")))

Best wishes,
Javaid

[Sam Capricci]

maybe... =IF(AND(A2="",B2=""),"",IF(AND(A2<>"",B2<>""),A2&" & "&B2,IF(A2<>"",A2,B2)))
and change , to ; if your settings require it.

[dipsydoodle]

Thank you all for your help. I have the solution now.

Thank you

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.