Error in the IF condition

  • Thread starter Thread starter Mahesh
  • Start date Start date
M

Mahesh

When i am working on the IF condition i get the result as "False"
instead of Blanks. I used the below condition for Example;
if(a=20,5,"') where i am getting the result as false instead of
blanks. Can any one help me to know the reason as to why i am getting
false.
 
Assuming source numbers in A1 down

Try the IF like this in say B1:
=IF(A1+0=20,5,"")
Copy B1 down

The "+0" will help to coerce any text numbers in col A to real numbers for
the correct evaluation
 
You've presumably mistyped the formula in some way, but not the way you've
shown it here (with one double quote and one single). Don't try to retype
the formula for the group; copy and paste from the formula bar so that we
can see what you have done wrong.

Three questions are what the parameter separator character is set to be in
your system, what the thousands separator, and what the decimal separator?
 
You must log in or register to reply here.

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

Conditional Formatting with Calculated Blank 2
nested IF without repeating the condition to be tested 6
IF ERROR FORMULA 2
Conditional Formatting Applied when Statement Not True 6
IF(AND condition 1
If condition error 2
multiple if condition 6
Three possible outputs from an if statement. 3

Back
Top