For my powerlevelservice i'm trying to  make a calculator.

this code  calculates everything between level 1-70 @14gp/xp and from 70-99 @7gp/xp. But when i cross the 70 for example if i want to calculate: 40-85 it multiplies with 14. 

Is there anyway to get this work properly?

=ALS($B$9<=70;((VERT.ZOEKEN($C$9;$A:$B;2;0)-VERT.ZOEKEN($B$9;$A:$B;2;0))*14);ALS(C9<=71;(((VERT.ZOEKEN(70;$A:$B;2;0)-VERT.ZOEKEN($B$9;$A:$B;2;0))*7)+((VERT.ZOEKEN($C$9;$A:$B;2;0)-VERT.ZOEKEN(70;$A:$B;2;0))*7));((VERT.ZOEKEN($C$9;$A:$B;2;0)-VERT.ZOEKEN($B$9;$A:$B;2;0))*7)))

 

Cheers,

 

you can do 3 separate equations. for example Cell A contains the result of 40-70 prices, Cell B contains the result of 70-85 prices, Cell C contains A+B

EXPLANATION OF HOW TO DO IT:

--------------------------------------------------------------------------------------------------------------------

Format: int-int  -> from-to.

Case 1: If from-to is in the region of 1-70 do the first calculation, and 70-99 the second as it is. if/else if

Else

Case 2: Divide the calculation into 2 separate conditions.

1-) Check if from<=70 then 70-from individually

2-) if to>=70 then 99-to individually. after that add them up together and don't forget the remainder.

-----------------------------------------------------------------------------------------------------------------------------------------

I hope this helped you. Good luck!

Edited March 6, 20187 yr by inababila

So no chance of getting it fixed in one calculation?

11 minutes ago, Master00j said:

So no chance of getting it fixed in one calculation?

For me, that is my knowledge since I am not that professional yet. Maybe someone else with more experience will help

Edited March 6, 20187 yr by inababila

2 minutes ago, inababila said:

For me, that is my knowledge since I am not that professional yet. Maybe someone else with more experience will help

Yeah thanks for the reply i hope someone can help me to get it fixed in one calculation

3 minutes ago, Master00j said:

Yeah thanks for the reply i hope someone can help me to get it fixed in one calculation

Oh wait! Case 2 could do it in one calculation because it separates and calculates everything individually. From, and to alone, and then adds them up together.

Edited March 6, 20187 yr by inababila

Depending on how the sheet is set up, it should be possible for it to be done with nested IF/VLOOKUP functions. If you want me to take a look at it, let me know. 

Just now, DarkFaith said:

Depending on how the sheet is set up, it should be possible for it to be done with nested IF/VLOOKUP functions. If you want me to take a look at it, let me know. 

I could use some help yes .

whats your skype/discord?