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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,261
Members
412,709
Latest member
Rishu
Top