| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
| double match formula | Excel Worksheet Functions | |||
| When do we use -- (double minus) in a formula | Excel Worksheet Functions | |||
| Double lookup formula | Excel Worksheet Functions | |||
| Looking for how to do a double FIND formula | Excel Worksheet Functions | |||
Hybrid Mode
