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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mahesh" wrote:
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.