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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,429 Super User 2025 Season 2 on at

Like (1)

Report

Hi

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

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
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)

Was this reply helpful? Yes No