How do you use month formulas

[JessJacques]

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.

 

[PaddyD]

perhaps:

min(round(a1,b1),12)

 

[JessJacques]

Thank you so much. That worked......