tracking a deductible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Curtis

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

--
Regards
Roger Govier
Curtis said:
I am trying to create an excel spreadsheet for use by Medicare
Click to expand...
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
 
Back
Top