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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.