Forum Discussion
If/and/or question
consolidated city first last tampa matthew sanders How do I write an "if" statement for column A that returns all 3 of the words consolidated if the second two are what I am look...
I should have been more specific, sorry. Doesn't matter what B2 and C2 are, A2 should equal B2 and C2 combined. But, if B2 is tampa, C2 is matthew, and D2 is sanders, then A2 should equal all three combined.
How did the formulas I gave you work?