Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Conditional IF Statement

Topic Labels: Formulas
734 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben_Zavitz
4 - Data Explorer
4 - Data Explorer

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