Forum Discussion
HELP: what formula to use to calculate multiple dollar amounts within specific ages
Can someone please help me create a formula that will total amounts for three different numbers, considering a DOB/age. eg: 10,000 plus 5,000 will go for ages 50, then 10,000 plus 8,000 will go f...
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)