Thread: Logical IF statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wigi Wigi is offline
external usenet poster
  
Posts: 396
Default 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")?


Reply With QuoteReply With Quote