•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Developing a formula for assigning IRMAA premiums to incomes
Medicare premiums are based on income. I'm trying to write a formula that references a row of different incomes to a table that shows the annual IRMAA premiums. Using an IF formula to calculate premiums below the $218,000 is easy, as is the premium above the top threshold, but what would be the formula to reference the premium for income values between those levels?
| 2026 IRMAA Income Thresholds & Medicare Premiums | Part B | Annually/2 People |
|---|---|---|
| Less Than | $218,000 | 203 |
| 218-274k | $274,000 | 284 |
| 274-342k | $342,000 | 406 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#row zero
#cloud-based spreadsheet applications
#Excel alternatives
#IRMAA
#Medicare premiums
#formulas
#income thresholds
#Part B
#annual premiums
#thresholds
#income brackets
#premium calculation
#< $218,000