+ Start a Discussion

What is the difference between ISNULL and ISBLANK?

I am not sure which function should be used between ISNULL and ISBLANK.


Can anyone describe this for me?


Thank you in advance.

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

All Answers


This is very well described in the Help & Training area. Simply search for isblank or isnull to find it.


To put it short, use ISBLANK(). =)

Steve :-/Steve :-/
This was selected as the best answer
vijayabakarareddy yarrabothulavijayabakarareddy yarrabothula
Text fields are never null, that means even if you didn't provide any value ISNULL()  function  takes empty as a value.
  so using ISNULL() with a text field always returns false.
 For example, the formula field====  IF(ISNULL(new__c) 1, 0) is always zero regardless of the value in the New field.

For text fields, use the ISBLANK function instead.
  IF(ISBLANK(new__c) 1, 0)   true if if has a value 
  IF(ISBLANK(new__c) 1, 0)    false if it don't have a value