| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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")? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what formula for summing if two logical statements are true? | Excel Worksheet Functions | |||
| Logical Test if statements with text--Excel 2002 | Excel Discussion (Misc queries) | |||
| Intervals as logical statements | Excel Worksheet Functions | |||
| Logical ELSE statements | Excel Discussion (Misc queries) | |||
| Logical Function - Multiple IF statements | Excel Worksheet Functions | |||
Linear Mode
