Not sure why I am getting the error for having "

IF( Payoff_Amount__c -  Funding_Amount__c  > 0, Payoff_Amount__c - Funding_Amount__c , "None")

Error: Incorrect parameter type for function 'IF()'. Expected Number, received Text

  • i think your formula field Number data type but you returned None
    – sdandamud1
    Jul 31, 2019 at 0:30

1 Answer 1


Your formula is returning mixed types. If Payoff_Amount__c - Funding_Amount__c > 0, you return a number, Payoff_Amount__c - Funding_Amount__c. But otherwise, you return a string value, "None".

Formulas must return a consistent type. If you want to use the word "None", you'd need to change your formula to a Text type and convert the dollar value to text as well, using the TEXT() function.

You must log in to answer this question.

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