How many if statements i can use in single cell? one cell accepts only 8 if
statements. I want to assign conditions as given below:
Service Percentage
11 23
12 25
13 27
14 29
.. .
.. .

upto 30 years service I design three cells.
Year service Rate of Pension Amount
in year service user will enter 11, 12,13 etc. and the rate of pension will
automatically be calculated according to years, if 11 years service then 23%
etc.

Please help me.

specifically tell me how many if statements can be used in one cell and if i
want to check 20 conditions then is it possible?