[SalesForce] Formula Error: Syntax error. Extra ‘,’

I am trying to write a formula for opportunities but I keep getting the following error

Error: Syntax error. Extra ','

Here is my formula

    IF 
    (TODAY() > CloseDate && TEXT(StageName)='Donation Likely')
    || 
    (TODAY() > CloseDate && TEXT(StageName)='Donation Prospecting'),"Past              
    Due","Expecting")

Best Answer

The start Bracket ( of IF is missing. Try this one:-

IF(
     (TODAY() > CloseDate && TEXT(StageName)='Donation Likely')
     || 
     (TODAY() > CloseDate && TEXT(StageName)='Donation Prospecting'),
     "Past Due",
     "Expecting"
)
Related Topic