Help

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

Conditional IF Statement

Topic Labels: Formulas
194 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I have one table that has both insurance and investment products. The Product field splits these out. They share other common fields such as “Payment/Investment_Amount” and “Payment_Frequency”

Payment frequency holds single select options of weekly,biweekly, bimonthly, and monthly.

I am trying to create a statement specifically to calculate annual premium paid for insurance products. This is a conditional IF statement as the product has to equal insurance, then if it does, premium amount * frequency to equal annual payments.

Can someone assist? Much appreciated!

Thank you,
Ben

0 Replies 0