Formula help determining amount $ per year amount from scale

help!.xlsxCopie de Document remis au syndicat pour assemblée.xlsxHello,

So I've made this table in which I have the age of my employees, amount of the 1.5% to be removed from 0 to 57 years of age (increments of 888$ per year - 57 = 888 56 = 1776 ect)
Then I have the amounts payable from 58 till 65 (1220$ per year - 65= 1220$ 64= 2440$ ect)

What I need is a formula that would take these amounts in consideration and apply it automaticaly to the age varying on the age one might retire on. The basis is 58 so the amounts currently in the files are for a retirement at 58. Should the person leave at 59-60-61-62-63-64 or 65 I would need to also be able to get the amounts.

Bare with me it's all in french but here is a quick translation.

Columns

A
Employee number
B
Name
C
First Name
D
Date of birth
L
Date 2
N
Age
O
Amount 0-57 1.5%
P
Amount 58-65 1220$
and Q
is where I want the formula.

If you need additional information let me know!

Thanks in advance!

Copie de Document remis au syndicat pour assemblée.xlsx
help!.xlsx

Hello saniafe and welcome to the forum.

I am not able to reconcile the column descriptions above with what I see in the file.
Is there any chance the uploaded file is not what you intended? (It happens. Been there ... done that.)

Originally Posted by saniafe

Note that both files are there. Help! is just alot smaller and i'm guessing easy to miss!

Aha! Yes. I see it now.

saniafe

These seem to require some support files (columns O and P of the 'help!.xlsx' file). The other file doesn't seem to be what it's looking for and this one appears to be above my capabilities. I am going to call in the virtual Cavalry.

Reading the topic I suppose it will be a VLookup solution.

You need to explain better, what you want to achieve.

Please add all data in file (not 2 files) and post the expected result in your file. Please refer to the related cells, e.g. with a color.