tracking a deductible

[Curtis]

I am trying to create an excel spreadsheet for use by Medicare Beneficiaries. One of the objectives I'd like to accomplish is formulating a way for them to track their deductible (which is $100). Is there a way to format cells to deduct an amount consecutively from this $100 until it reaches zero, and then remain at zero until the following year? I have cells "Amount applied to deductible" and then "Remaining deductible"... Any help would be greatly appreciated... even a resounding "Forget it!" lol

Thanks in advance

 

[Roger Govier]

Hi Curtis

Assuming deductibles are entered in cells A2:A100
In cell A1 enter
=MAX(0,100-SUM(A2:A100))

--
Regards
Roger Govier

I am trying to create an excel spreadsheet for use by Medicare

Beneficiaries. One of the objectives I'd like to accomplish is formulating a
way for them to track their deductible (which is $100). Is there a way to
format cells to deduct an amount consecutively from this $100 until it
reaches zero, and then remain at zero until the following year? I have cells
"Amount applied to deductible" and then "Remaining deductible"... Any help
would be greatly appreciated... even a resounding "Forget it!" lol

 

[Curtis]

Genius! Thank you so much Roger

 

[Roger Govier]

Genius!
Hardly, but glad you found it useful.