Jul 20 2020 12:34 AM
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
Jul 20 2020 04:17 AM
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%)
Jul 20 2020 04:49 AM
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.
Jul 20 2020 06:20 AM
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.