If formula required

[pallu]

Age	sum assured	Premium
51-60	500000​	1000​
61-70	400000​	2000​
71-80	300000​	3000​
81-90	200000​	4000​
emp code	emp name	age	deduction amount
xxx	yyyy	71-80	3000​
Please help with formula in deduction amount column

 

[pallu]

hi

attached working sheet for your reference

 

[Marcilio]

pallu, Good morning.

You're asking for an IF Function solution.

Try this one:

D8 --> =IF(C8>80;4000;IF(C8>70;3000;IF(C8>60;2000;IF(C8>50;1000;0))))

BUT, if you can modify your table, you will have the benefit of using the VLOOKUP function.

See the example I created for you.

Was this what you wanted?

Hope this helps.

 

[pallu]

Hi
Thanks for the forumula

if sum assured amount is not consider in the formula Eg: sum assured amount is 4lakh premium amount will differ according to the age selection

regards
PP

 

[pecoflyer]

Perhaps =LOOKUP(C8,A2:A5,C2:C5)
(I have no idea what "lakh" means please use terms everyone can understand without having to loose time searching the net. Thanks)