Yearly and quarterly bills per month

Premium

In D2, turn the amount in B2 into a monthly amount: divide yearly bills by 12 and quarterly bills by 3, and keep monthly bills as they are. Put one IF inside another.

D2
ABCDEF
1Bill Amount Paid Per month
2Car insurance 4800 Yearly
3Rent 3000 Monthly
4Water 900 Quarterly
5Phone 250 Monthly
6Gym 3000 Yearly
7
8

Premium lesson

Unlock Budget and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?