My forumla in my spreadsheet is failing and causing my flow to fail

(1) Share

Report

Posted on by GS-10091255-0

I am doing something wrong and I'm hoping someone can help. I have created a flow to send a certificate to people who correctly answer two questions on a Forms quiz. Each question is worth 1 point so you need 2 points to get the certificate. I cannot figure out why my formula in the spreadsheet keeps adding up incorrectly. Even when the quiz is answered correctly the "score" isn't adding up to 2. It adds up only to 1 and so everyone gets a 'you failed' email. It's probably something simple but I cannot see it. Here's the
formula: =SUM(IF(D3="An ABLE account", "1", "0"))+(IF(E3="TRUE", "1","0")). Thanks

Categories:

General topics

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

You should really post this in the Office forums, as it doesn't have anything to do with your flow.
Suggested answer

David_MA 15,536 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
As FLMike mentioned, these forums are for the Power Platform and your issue is really with an Office application and you don't show how your flow is failing due to an expression in your spreadsheet. But there are a couple of issues with your Excel expression:

SUM Function: The SUM function is unnecessary here because you are not summing a range of numbers, but rather adding two individual IF statements.

IF Function: The IF function should return numbers (1 or 0) instead of text (“1” or “0”).

Here’s a corrected version of your formula:

=IF(D3="An ABLE account", 1, 0) + IF(E3=TRUE, 1, 0)