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.
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.