Logical IF statements

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiples of 4 in an IF statement 6
Creating popup messages for User Defines Functions 1
Nested IF Statements - Worksheet Function 2
Why do functions not allow commas to seperate arguments 5
#NAME? error in nested if & VB 1
Function for Auto Populate 3
Formula Bar Syntax Tips Disappeared! 1
any limit? 2

Back
Top