How do you use month formulas

JessJacques

New Member
Joined
Oct 20, 2005
Messages
12
Hi All,

Maybe someone can help me. I know this is probably really simple, that is probably why I can not figure it out. Here is my issue.

This is in regards to trying to figure out how many months are left before hitting a deductable. So if I my client is spending $112 per month, which is $1334 per year, and they have to hit $2250 deductable before they have to pay retail. I need to figure out how many months this will take them until this happens. My formula comes out to 20 months, so I have to have the formula revert automatically to 12, since that is how many months are in a year. So I have $2250/112 = 20, I need this to go to 12 by default. Can anyone help me with this. I would greatly appreciate it because I am stumpt.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,632
Messages
5,832,772
Members
430,166
Latest member
Nige Leeming

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top