▲ 2 r/excel
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 |
u/Lazy-Ad-6453 — 14 days ago