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")?

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")?

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")?

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")?