I am trying to come up with a double IF statement and I'm not sure if any
sort of formula exists. I am actually using text as well. I want to do
something like IF cell A5="SOMATIC" and cell A6="VISUAL" then cell
A7="SOMATICVISUAL". I basically can't figure out the "logical test" part of
the syntax. Might look something like this?

=IF(A5="SOMATIC;A6="VISUAL","SOMATICVISUAL","")

That didn't work. Neither did a colon in place of the semicolon, or
parentheses around the second IF statement. Any help is much appreciated.
Thanks!