Easy way to make an IF

[Mr_Blue1993]

I'am kinda new at using If.

Is there a easy way to make a very long one?

What i want to do is....

if A1 is 200 then do A2 * 0.50 But if its 300 then do A2 * 0.75 but if it is 400 then do A2 * 0.6 and so on.... for about 30 ifs...

 

[Mr_Blue1993]

It looks as if its locked to the place where 8450 stood, Even if i make it 999999999999 it will still change the calculation on 9100

 

[AliGW]

I'd need to see the file. DropBox link?

 

[Omer_K]

It looks as if its locked to the place where 8450 stood, Even if i make it 999999999999 it will still change the calculation on 9100

The number 8450 is the last number on the array list?

 

[Mr_Blue1993]

The number 8450 is the last number on the array list?

No it's not the last number, there is one beneath it.

 

[Omer_K]

No it's not the last number, there is one beneath it.

So in that case can you upload the file to Dropbox?
i need to see the file..

 

[Mr_Blue1993]

I'd need to see the file. DropBox link?

I have sent you a PM with the DropBox link.

 

[Mr_Blue1993]

I found the problem. Well found..... changed the formula so it needs an exact match. and that fixed it.

 

[AliGW]

Good to know - thanks for telling us!

 

[Mr_Blue1993]

Thanks for all your help guys/girls!

 

[AliGW]

You're welcome!