Excel Automation doubt

I have 5 coloumn for 5 subject and one more coloumn for number of failed subject. if any sub marks is less than 40 i want to display number of fail subject for every less than 40 marks and if there are more than 40 marks in all subject i have to display NA .how to do i have 5 rows for 5 students

Hello @Pushpreet_Singh1 ,

You can easily achieve this using a for loop and a condition to check the score of each subject as below :
image

Please find the solution here.
Forum_VerifySubjectMarks.zip (2.2 KB)

Let me know if u face any issues here.

Regards,
Rohith

Hello @Pushpreet_Singh1 , Kindly refer this flow, it may helps you

SubjectPassFail.zip (85.1 KB)

Happy Automation

Regards,
Gokul Jai

1 Like

workflow activities not opening

Hello @Pushpreet_Singh1 ,

Can you open this and check.
Forum_SubjectmarksCheck.zip (3.2 KB)

yeah thanks…

If it works for you, kindly mark it as solution for others reference.

Regards,
Rohith

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.