Forum Discussion
Excel ALS function
Hi all,
I tried to made a formula with ALS and i need to add more funtion arguments but it gives an error and i dont know why.
=ALS(AC7=0;45%; ALS(AC7=1;51%; ALS(AC7=2;56%; ALS(AC7=3;62%)))) this is the formule for now
i need the following 4=67%, 5=73%, 6=78% and 7=85%
kind regards,
jeffry
3 Replies
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.
