New Contributor

# 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

# Re: 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%)

# Re: Excel ALS function

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.

# Re: Excel ALS function

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.