Skip to main content
Solved

No of Payments Summary Formula

  • March 1, 2023
  • 1 reply
  • 15 views
A
Forum|alt.badge.img

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

Best answer by TheTimeSavingCo

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

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6414 replies
  • Answer
  • March 1, 2023

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} )
Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement