# Formula for Invoiced Amount per Invoicing Schedule

Options
✭✭✭✭

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!

## Answers

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭
Options

Thank you Andrée!!

• ✭✭✭✭✭✭
edited 08/17/21
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!