Formula for Invoiced Amount per Invoicing Schedule

Tori Heath

Hi Community,

I'm looking for a formula that will divide an annual fee by the # of invoices sent per year. If quarterly divide by 4, if monthly divide by 12 and if semi-annually divide by 2.

I think it's something like this but I can't quite get it:

=IF([O&M Invoicing Frequency]@row = "Quarterly", ([O&M Current Year Fee]@row / 4), IF([O&M Invoicing Frequency]@row) = "Monthly", ([O&M Current Year Fee]@row / 12), IF([O&M Invoicing Frequency]@row) = "Semi-annually", ([O&M Current Year Fee]@row / 2))

Thank you in advance!

Andrée Starå

Hi @Tori Heath

I hope you're well and safe!

You were very close. You had a couple of parentheses in the wrong places.

Try something like this.

=
IF([O&M Invoicing Frequency]@row = "Quarterly", [O&M Current Year Fee]@row / 4, 
IF([O&M Invoicing Frequency]@row = "Monthly", [O&M Current Year Fee]@row / 12, 
IF([O&M Invoicing Frequency]@row = "Semi-annually", [O&M Current Year Fee]@row / 2)))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Tori Heath

Thank you Andrée!!

Andrée Starå

@Tori Heath

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!