Syntax Errors?
Syntax Errors?
I can't seem to see the errors in this one.
Here are my goals:
If ${Accounts.Prelim Financed Amount} <= 20000, then 395
If ${Accounts.Prelim Financed Amount} <= 50000, then 595
If ${Accounts.Prelim Financed Amount} <= 100000, then 795
If ${Accounts.Prelim Financed Amount} > 100000, then 995
This is the nested forumla I have, but it keeps coming up with syntax errors...
IF((${Accounts.Prelim Financed Amount}<=20000),’395’,(IF((${Accounts.Prelim Financed Amount}<=50000),’595’,(IF((${Accounts.Prelim Financed Amount}<=100000),’795’,(IF((${Accounts.Prelim Financed Amount}>100000),’995’,’0’)))))))
Can anyone help please?