formula for double If statements

  • Thread starter Thread starter GLHEC-BLS
  • Start date Start date
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!
 
One or two more:

=IF(AND(A5="SOMATIC",A6="VISUAL"),a5&a6,"")
or
=IF(AND(A5="SOMATIC",A6="VISUAL"),upper(a5&a6),"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement 2
solving nested IF statements 13
Two formulas in one cell 3
Assessment Worksheet 1
Adding formulae 3
Help with time formula 12
Beginer's problemBeginner's problem 6
Need help with a formula with zero 5

Back
Top