cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteveSh
New Member

Excel Cell Formula grading not working

Hello everyone. I can't seem to figure out how to configure the following formula to calculate correctly:

 

=SUM(IF(D2="Yes", "10", "0"))+(IF(E2="Yes", "10", "0"))+(IF(G2="Immediately", "10", "0"))+(IF(H2="Yes", "10", "0"))+(IF(I2="No", "10", "0"))+(IF(J2="Quarter", "10", "0"))+(IF(K2="All workers", "10", "0"))+(IF(F2="Hard Hat AND Safety Glasses AND High Visibility Outer Layer AND Full Length Pants AND Shirt with at least a 4 inch sleeve AND Sturdy Leather Work Boots", "10", "0"))

 

I'm setting up a Power Automate flow to grade tests and print out certificates. One of the questions has multiple answers (F2), but it doesn't calculate that block. The formula without F2 works great! What am I missing? When I look at the Excel block with data, this is what it shows in the block:

 

["Hard Hat","Safety Glasses","High Visibility Outer Layer","Full Length Pants","Sturdy Leather Work Boots","Shirt with at least a 4 inch sleeve"]

 

Please help me configure this. Thank you!!!
Steve

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,527)