You need to sign in to do that

Don't have an account?

shalu

- Apex Code Development (90768)
- General Development (55146)
- Visualforce Development (37251)
- Lightning (18265)
- APIs and Integration (17146)
- Trailhead (11680)
- Formulas & Validation Rules Discussion (11337)
- Other Salesforce Applications (8116)
- Jobs Board (6655)
- Force.com Sites & Site.com (4842)
- Mobile (2694)

You need to sign in to do that

Don't have an account?

Sorna JenefaHi,

I can't understand..

What did u ask...

But i think you ask like this...

IF( M1__c >=35,'',' M1') + IF(M2__c >=35 ,'',' M2') +IF(M3__c >=35,'',' M3') +IF(M4__c >=35,'',' M4') +IF(M5__c >=35,'',' M5')+ IF(M6__c >=35,'',' M6')

M1__c ----->Subject fields

M1 replace into english

M2 '' '' maths

Thanks,

Jenefa

Sweet Potato Tec

## All Answers

Sorna JenefaHi

6 --->Marks field ------->Number(m1...m6)

Grade field :

Data Type Formula (Text)

IF( M1__c >35 && M2__c >35 && M3__c >35 && M4__c >35 && M5__c >35 && M6__c >35, 'A', 'F')

Count field for failed subject :

Formula Number field:

IF( M1__c >=35,0,1) + IF(M2__c >=35 ,0,1) + IF(M3__c >=35,0,1) +IF(M4__c >=35,0,1) +IF(M5__c >=35,0,1)+IF(M6__c >=35,0,1)

Formula Text field:

TEXT(IF( M1__c >=35,0,1) + IF(M2__c >=35 ,0,1) +IF(M3__c >=35,0,1) +IF(M4__c >=35,0,1) +IF(M5__c >=35,0,1)+ IF(M6__c >=35,0,1))

Let me know if its works as you excepted.

Please mark it as solved so that it will be helpful to others

Thanks,

Jenefa

Sweet Potato Tec

Sorna JenefaHi,

Please share the screenshot ....

I will help you ....

Sorna JenefaOK

Sorna JenefaHi

Please Now try this

IF( M1__c >=35,'','M1') + IF(M2__c >=35 ,'','M2') +IF(M3__c >=35,'','M3') +IF(M4__c >=35,'','M4') +IF(M5__c >=35,'','M5')+ IF(M6__c >=35,'','M6')

Thanks,

Jenefa

Sweet Potato Tec

shaluhow to create it?.. Sorna JenefaHi,

I can't understand..

What did u ask...

But i think you ask like this...

IF( M1__c >=35,'',' M1') + IF(M2__c >=35 ,'',' M2') +IF(M3__c >=35,'',' M3') +IF(M4__c >=35,'',' M4') +IF(M5__c >=35,'',' M5')+ IF(M6__c >=35,'',' M6')

M1__c ----->Subject fields

M1 replace into english

M2 '' '' maths

Thanks,

Jenefa

Sweet Potato Tec

shaluIF( M1__c >=35,

, 'M1')''why we using ( ' ' ) this thing here? can u explain it..

Sorna JenefaHi,

Single quotes for whitespace between Failed subject

M1 M2 M3orEnglish Maths Science---->like thisshaluhi , how to create an rating for marks (like A++,A,B,B++,C,D,F)total marks should be count and grade use like that...

shalucan anyone explain this thing.... Chris Glover 7Sounds like a complicated project Chris Glover 7I can say that most of the projects I have are complicated. And sometimes, it took me so much time to finish it, and still, sometimes, there might help me some mistakes. But I'm a student, and I need those mistakes to become better and improve my skills. But I have many other tasks, and sometimes it's problematical to do everything. But I will do my best, besides there are different services which may help you. I've been using this site https://supremestudy.com/ with different free essay examples for a long time, and those examples save me so much time. And I can dedicate that free time to my projects because that's something I like and want to connect my future with.