Forum Discussion
Excel ALS function
Like this:
=ALS(AC7=0; 45%; ALS(AC7=1; 51%; ALS(AC7=2; 56%; ALS(AC7=3; 62%; ALS(AC7=4; 67%; ALS(AC7=5; 73%; ALS(AC7=6; 78%; ALS(AC7=7; 85%))))))))
Alternatively:
=ZOEKEN(AC7; {0; 1; 2; 3; 4; 5; 6; 7}; {0,45; 0,51; 0,56; 0,62; 0,67; 0,73; 0,78; 0,85})
Or:
=SCHAKELEN(AC7=0; 45%; AC7=1; 51%; AC7=2; 56%; AC7=3; 62%; AC7=4; 67%; AC7=5; 73%; AC7=6; 78%; AC7=7; 85%)
is there any possibility that the formule can be in the exact cell? I dont think so but I thought it was worth to shoot the shot anyways. for example if I put in the number in AC7 that the result will be also be shown in AC7.
Nope, formula can't take the cell value, perform some calculations and return result into the same cell. With very few and very specific exceptions result shall be returned to another cell.
