 ShowAll Questionssorted byDate Posted shalu

# create an object as students course,marks field 6 subject,if score as below 35 means ,grade= should should be 'F' or if above 35 means grade= should be 'A',and then failed subject = should count how subject as failed in (text)...using formula field. Best Answer chosen by shalu Sorna Jenefa
Hi,
I can't understand..
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 Sorna Jenefa
Hi

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

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 Jenefa
Hi, Sorna Jenefa
OK Sorna Jenefa
Hi

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 shalu
how to create it?.. Sorna Jenefa
Hi,
I can't understand..
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
This was selected as the best answer shalu
IF( M1__c >=35,     ''      ,  'M1')

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

Single quotes for whitespace between Failed subject

M1 M2 M3 or  English Maths Science  ---->like this shalu
hi ,
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... shalu
can anyone explain this thing.... Chris Glover 7
Sounds like a complicated project Chris Glover 7
I 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.