Reference a particular cell dependent on age column

[moebfd]

Hi All,

I was wondering if anyone here can help me. Am sure someone will.

I have a basic spreadsheet to calculate salaries. I have now added a date of birth column and an age column. The age column is calculated by a formula which references the date of birth column.

Now, what I want to do is dependent on their age, I need the “TOTAL” to calculate a rate (B11:C14) x either shift worked or hh:mm worked out automatically, so I don’t need to reference each cell (B11:c14) individually.

P.S. At present it only references B11 and C11.

I attach a spreadsheet which I devised previously which just does a basic calculation on one cell. Now I need it to reference a few cells depending on the age.

Thanking you for all your help.

With Regards.
Moebfd.