Hi Curious Dude,
Try this formula,
=IF(AND(NOT(A3=""),B3=""),A1,IF(AND(NOT(B3=""),A3=""),B1,IF(AND(NOT(A3=""),NOT(B3="")),A1& " and " & B1,IF(AND(A3="",B3=""),""))))
paste it in cell h1.
Hi Curious Dude,
Try this formula,
=IF(AND(NOT(A3=""),B3=""),A1,IF(AND(NOT(B3=""),A3=""),B1,IF(AND(NOT(A3=""),NOT(B3="")),A1& " and " & B1,IF(AND(A3="",B3=""),""))))
paste it in cell h1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks