IF Formula, Extra ',' Error

I'm trying to create a formula based on combination of 2 fields. Not sure what I'm missing.

(Class Name = Application & Application Count is not blank) = application count +1
(Class Name != Application & Application Count is not blank) = application count
(Class Name = Application & Application Count is blank) = 1
(Class Name != Application & Application Count is blank) = 0

IF(
AND(
Class__r.ClassName__c = 'Application',
NOT(ISBLANK(Application_Count__c)), Application_Count__c + 1)),
IF(
AND(
Class__r.ClassName__c != 'Application',
NOT(ISBLANK(Application_Count__c)), Application_Count__c)),
IF(
AND(
Class__r.ClassName__c = 'Application',
ISBLANK(Application_Count__c))),1,
IF(
AND(
Class__r.ClassName__c != 'Application',
ISBLANK(Application_Count__c),0,NULL))

May 26, 2015
·
Like
0
·
Follow
2

Best Answer chosen by Skeeter

Prabhat Kumar12
Please use updated formula

IF( AND( Class__r.ClassName__c = 'Application', NOT(ISBLANK(Application_Count__c))), Application_Count__c + 1 ,IF( AND( Class__r.ClassName__c != 'Application', NOT(ISBLANK(Application_Count__c))),Application_Count__c, IF(AND( Class__r.ClassName__c = 'Application', ISBLANK(Application_Count__c)),1, IF( AND( Class__r.ClassName__c != 'Application', ISBLANK(Application_Count__c)),0,NULL))))

May 26, 2015
·
Like
1
·
Dislike
0

Skeeter
I am now receiving Error: Incorrect parameter type for function 'AND()'. Expected Boolean, recieved Number.

May 26, 2015
·
Like
0
·
Dislike
0

This was selected as the best answer

Skeeter
Yeah! That worked. Thank you!

May 26, 2015
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

IF Formula, Extra ',' Error

All Answers

You need to sign in to do that.