Re: HELP: what formula to use to calculate multiple dollar amounts within specific ages

I'd create a lookup range. In the screenshot it is in E2:F4 but it can be anywhere.

The formula in C2 is

=10000+XLOOKUP(B2, $E$2:$E$4, $F$2:$F$4, 0)