You need to sign in to do that
Don't have an account?
Lisa Lee-Banks
Need the correct formula field syntax for IF
I'm trying to create a formula field for loan anniversary date which is determined by the renewal date and the term of the loan (number field). If the term of the loan is 5 years then the 4 year anniversary date is the renewal date - 365 days.
Currently I have this syntax but there's a syntax error:
IF(
(Term__c) = 5),
(Renewal_Date__c) - 365
)
Currently I have this syntax but there's a syntax error:
IF(
(Term__c) = 5),
(Renewal_Date__c) - 365
)
What is the error that you see?
Thanks,
Similarly, what sort of field is Term__c?
This would work if Term is a number field. If a picklist If you are wanting multiple options, rather than a nested IF when you are just checking the Term field, you could use CASE regards
Andrew
Have a great day
Andrew