Anyone here really good at maths?

[Xeanor]

I'm making a cast speed calc, but I need to be able to sort on RA points cost

So how do I make a formula that will say:

When i enter: Aug Dex 1, it wil say: that costs 1 point total
When i enter: Aug Dex 2, it wil say: that costs 4 points total
When i enter: Aug Dex 3, it wil say: that costs 10 points total
When i enter: Aug Dex 4, it wil say: that costs 20 points total
When i enter: Aug Dex 5, it wil say: that costs 34 points total

Well it's about the 1st and the 2nd number, you need to multiply the 1st one with something else to get the 2nd number, but what? I can't work it out at least.

 

[katt!]

augdex[1]=1
augdex[2]=4

etc? :x

 

[Xeanor]

How do I do that in Excel and specify it to 1 column?

 

[Xeanor]

little preview of what I'm making:

http://picserver.student.utwente.nl/getpicture.php?id=335956

 

[Breni]

You could try this:

=IF(A1=5,A1*6.8,(IF(A1=4,A1*5,(IF(A1=3,(SUM(4*2.5)),(IF(A1=2,A1*2,(IF(A1=1,1)))))))))

Assuming A1 is the cell in which you place the value of Aug Dex, the formula will calculate the result in whichever cell you place it.

The last text entry in the formula checks for values outside the range and returns the "error" therein.

Hope it helps

 

[Stina Handfast]

Or simply without the multiplicators:

=IF(A1=1;1;
IF(A1=2;4;
IF(A1=3;10;
IF(A1=4;20;
IF(A1=5;34;0)))))


edit: will display 0 if value of A1 (i.e. level of aug dex) is 0

 

[Breni]

Or you could do that, of course!

 

[Xeanor]

Thanks Breni, that worked.

 

[cHodAX]

Nice