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,