formula for double If statements
 

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!

formula for double If statements
 

Use AND

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

"GLHEC-BLS" wrote:

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!

formula for double If statements
 

Hi GD
Try this:
=IF(AND(A5="SOMATIC",A6="VISUAL"),"SOMATICVISUAL", "")


"GLHEC-BLS" wrote in message
...
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!

formula for double If statements
 

Awesome! It works great. Thanks a lot.

"akphidelt" wrote:

Use AND

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

"GLHEC-BLS" wrote:

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!

formula for double If statements
 

One or two mo

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




GLHEC-BLS wrote:

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!

--

Dave Peterson