Question

Create a Fomula in Forms

Forms

Updated March 1, 2021

asked on March 1, 2021

Need some help putting a formula together in forms. What I put together doesn't seem to work. SUMIF(amount, > "200.00") So this works if the single row is > 200.00 but I need to sum all rows to come up with that. Also I need multiple that final number if > than $200 by .003. Can some please advise how I would put that formula together in forms. Thanks

0 0

Answer

SELECTED ANSWER

replied on March 1, 2021 • Show version history

The & symbol is CONCATENATE - it's just combining > and 200.00 to mean >200.00 - that works the same way in Excel.

I misunderstood the question and thought you were only wanting to sum the values that were greater than $200.00.

This formula will check if the sum if more than $200 - if it is, it'll multiply that sum by 0.003 - if it is not, it'll just return zero.

=IF(SUM(test_table_5.column1) > 200.00, SUM(test_table_5.column1) * 0.003, 0)

SUMIF is saying to sum some of the values in the table, if something is true. SUM is summing every value in the table.

1 0

Replies

replied on March 1, 2021

Hey @████████,

This formula sums all of the column1 values in test_table if the values are > 200.00. Then it multiples the resulting total by 0.003.

=SUMIF(test_table.column1, ">" & 200.00) * 0.003

1 0

replied on March 1, 2021

Thank you Matthew, that worked.

1 0

replied on March 1, 2021

does the & sum the rows? Still doesn't seem to be working as desired.

row 1 amount=201.00

row 2 amount = 50.00

row 3 amount = 250.00

Only uses row 1 and 3. I need the .003 to multiply off of sum of $501. IF the sum is > $200 then the .003 applies, if not it's $0

0 0

SELECTED ANSWER

replied on March 1, 2021 • Show version history

The & symbol is CONCATENATE - it's just combining > and 200.00 to mean >200.00 - that works the same way in Excel.

I misunderstood the question and thought you were only wanting to sum the values that were greater than $200.00.

This formula will check if the sum if more than $200 - if it is, it'll multiply that sum by 0.003 - if it is not, it'll just return zero.

=IF(SUM(test_table_5.column1) > 200.00, SUM(test_table_5.column1) * 0.003, 0)

SUMIF is saying to sum some of the values in the table, if something is true. SUM is summing every value in the table.

1 0

You are not allowed to follow up in this post.

Question

Question

Create a Fomula in Forms

Answer

Replies

Sign in to reply to this post.