If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Logical IF statements
When using the IF statement:
IF(logical_test,value_if_true,value_if_false) Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low") be written as =IF(A1=very low,"1")? |
#2
|
|||
|
|||
Logical IF statements
Like this?
=IF(A1="very low",1) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Matt" wrote: When using the IF statement: IF(logical_test,value_if_true,value_if_false) Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low") be written as =IF(A1=very low,"1")? |
#3
|
|||
|
|||
Logical IF statements
Sweet, thanks..!
"Wigi" wrote: Like this? =IF(A1="very low",1) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Matt" wrote: When using the IF statement: IF(logical_test,value_if_true,value_if_false) Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low") be written as =IF(A1=very low,"1")? |
#4
|
|||
|
|||
Logical IF statements
You may need to explain to the OP that the quote marks are to delimit a text
string. A number doesn't have quote marks. Quote marks around "1" make it a text string, not a number. -- David Biddulph "Wigi" wrote in message ... Like this? =IF(A1="very low",1) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Matt" wrote: When using the IF statement: IF(logical_test,value_if_true,value_if_false) Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low") be written as =IF(A1=very low,"1")? |
Thread Tools | |
Display Modes | |
|
|