Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# Support required with if formula

Topic Labels: Formulas
183 3
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Hi all

I would really appreciate some support to come up with the correct formula for the columns in the screenshot below.

I want the price in the standard pricing column to auto-populate when a selection has been made in the payment options column.

For example, suppose I select 10 instalments in the payment options column. In that case, I want the standard pricing column to automatically associate \$150 with this option and then automatically add the \$150 to the standard pricing column.

The same, for example, with the option paid in full, should automatically add \$1500 in the standard pricing column.

Your support with this is highly appreciated.

Thank you

3 Replies 3
16 - Uranus

Assuming that the total is always 1500, your formula would be pretty simple using SWITCH() and some math. Convert your {Standard Pricing} column into a formula using:

``````1500 / SWITCH(
{** Payment Options},
'10-installments', 10,
'3-installments', 3,
'Paid in full', 1
)
``````

^ in plain English, the formula is saying “if Payment Option is 10-installments divide 1500 by 10, if its 3-installments divide by 3, if its paid in full divide by 1”

6 - Interface Innovator

This is great, Kamille.

You mentioned a good point about the pricing being the same or different.

• The cost associated with “10-instalments” is \$155 per instalment. This means that 10 instalments will cost \$1 550 in total.
• The cost associated with “3-instalments” is \$510 per instalment. This means that 3 instalments will cost \$1 530 in total.
• The cost associated with “Paid in Full” is \$1 500 once off.

I want to add n/a (not applicable) to my Payment Options column, which should be associated with \$0. Is this possible?

Thanks

16 - Uranus

The the formula is even simpler.

``````SWITCH(
{** Payment Options},
'10-installments', 155,
'3-installments', 510,
'Paid in full', 1500,
'n/a', 0
)
``````