I have created a formula field to calculate a score from other two fields. If the condition succeeds, the score will be a static value else the field value. The condition is

IF (AND (ISPICKVAL (object1,"object value"), VALUE (object2)=null), static value, VALUE (object2))

But the condition always fails even the scenario is correct. Is there any mistake in writing this formula? [Note: There is no syntax error when I hit "Check Syntax"]

Thanks in Advance.

1 Answer 1


You need to use the ISNULL() function instead of checking the Value(Object2)=null.

Change to this



As @Sdry points out, you could also use


ISBLANK() is a newer function, it has the same functionality as ISNULL, but also supports text fields. So as Sdry points out, it is highly preferred over ISNULL(). ISNULL() will still work, just not the preferable function.

  • 4
    IsBlank() is highly prefered over isnull() Commented Sep 17, 2013 at 11:41
  • Agreed. Edited the answer to reflect Commented Sep 17, 2013 at 11:48
  • IsBlank() makes the formula to work fine.
    – Dinesh
    Commented Sep 17, 2013 at 13:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .