Calculate the result based on excel values

Hi Team,

I want to calculate the result based on excel values as below

If Policy Term is 1 and policy year is 1 the result is 7.80
If Policy Term is 1 and policy year is 2 the result is 0.00
If Policy Term is 2 and policy year is 1 the result is 9.50
If Policy Term is 2 and policy year is 2 the result is 5.70
image

Based on term and year i want to calculate the result

Appreciate your help!

Appreciate your help @Palaniyappan @lakshman @Lahiru.Fernando

@RajeshT

It’s looks like excel cells are merged here and it’s very difficult to get values from this.

@balupad14

Do you have any solution here ?

2 Likes

Hi @lakshman,

I think if he start the range 3rd row without header, he can achieve it.

Thank you
Balamurugan.S

2 Likes

@balupad14

Yes if the data is in this fixed format then we can achieve this.

@RajeshT

Is this data always be in the same format along with same columns ?

2 Likes

Hi @lakshman, yes data will be fixed .
Please give me your inputs how to start ,then i will proceed.
Thank you in advance.