# No of Payments Summary Formula

Topic Labels: Data Formulas
Solved
256 1
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi I am new to airtable and trying to figure out the formula, but stuck on figuring how to accomplish the following.  We have the following fields

Deal Value = X Amount

No of Payments = can be 1 or more

• If its 1 = then we need the formula to be (Deal Value / 1) = goes in Payment #1 Amount Column
• If its > 1 = then we need the Deal Value / No of Payments = go to multiple Payment Columns (Payment #2, Payment #2....... Payment #12)

We have created multiple columns with a formula as Payment #2, Payment #3..... Payment #12 with the formula as {Deal Value}/ {No of Payments). However, if the No of Payments is 1, this scenario replicates for that row. We like to write a formula for the payment fields (2-12) which can derive the payment amount by

IF No of Payments = 1, then "0" ELSE  {Deal Value/No of Payments) in the formula field.

Any insights, what formula should I use for the payment fields to achieve this output? Thank you all very much. Veejay

1 Solution

Accepted Solutions
16 - Uranus

I think you've pretty much got it figured out actually, the line you have in bold is exactly the logic you'd need

``````IF(
{No of Payments} = 1,
0,
{Deal Value} / {No of Payments}
)``````
``````IF(