Apex Code Development You need to sign in to do that
Don't have an account?
DRPowerUser Nested IF Formula Not Working Properly
I thought I had my formula working, but when I combine 2 "AND" IF statements together it breaks.
| IF( Qualifier__c <> OwnerId , |
| IF( Users__c < 20, 60, |
| IF( Users__c < 50, 100, |
| IF( Users__c < 100, 250, |
| IF( Users__c >=100, 500,NULL)))),0) |
This works fine.
| IF (ISPICKVAL(StageName, "Closed Won"), |
| IF( |
| Users__c<20,150, |
| IF( |
| Users__c<50,300, |
| IF( |
| Users__c<100,750, |
| IF( |
| Users__c>=100,1500,0)))),0) |
This works fine.
My issue is that I'm trying to combine the IF statements in each of the first 2 sets of formulas.
| IF (AND (ISPICKVAL(StageName, "Closed Won") Qualifier__c<> OwnerId, |
| IF( |
| Users__c<20,150, |
| IF( |
| Users__c<50,300, |
| IF( |
| Users__c<100,750, |
| IF( |
Users__c>=100,1500,0))))),0)
This creates an error. Any assistance on how to resolve???? |
It says invalid parameters. You can try and cut and paste in that formula and it will give syntax error.
All Answers
It says invalid parameters. You can try and cut and paste in that formula and it will give syntax error.