Forum Discussion
CAM2019
Feb 21, 2025Copper Contributor
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 for ages 51, and then 10,000 plus 9,000 will go for ages 52.
would it be an IF statement? I am having a hard time adding multiple scenarios.
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)