- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 28, 2023 06:54 PM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2023 12:57 AM
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}
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2023 12:57 AM
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}
)
