Base Premium - Workings

[Raghunathan]

Dear All,

Request your help to get the formula to extract base premium as per the following:

a) Age
b) Dependents
c) Sum Insured

The premium grid is also attached as the supplementary sheet.

Thanks in advance.

Raghuanthan S

 

[AliGW]

Which version of Excel are you using?

 

[AliGW]

If you have 2024 or 365:

=TAKE(FILTER(FILTER(Calculator!$D$2:$R$21,(Calculator!$C$2:$C$21=F2)*(Calculator!$B$2:$B$21>=E2)),Calculator!$D$1:$R$1>=G2),1,1)

 

[Raghunathan]

MS office 2013