Multiple if statements in one cell
If you have max 29 choices then
=CHOOSE(A1-10,23,25,27,29,30,31,32,33,34,35,36,37,38,39,40,41 ,42,43,44,45)
return percentages shown in your table.
Replace percentage numbers to your real values.
You can use also VLOOKUP if you store your table in a separate sheet.
IF function can be embedded up to 7 levels. If you have more than 7
conditions you have to choose some other solution but there is no recipe, the
solution depends on the actual task.
Regards,
Stefi
a.g. ezt *rta:
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?
|