formula for double If statements

G

GLHEC-BLS

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!
 
D

Dave Peterson

One or two more:

=IF(AND(A5="SOMATIC",A6="VISUAL"),a5&a6,"")
or
=IF(AND(A5="SOMATIC",A6="VISUAL"),upper(a5&a6),"")
 
Top