Loading...
 
Features / Usability

Features / Usability


help with advanced formula

posts: 220 Ukraine

Hi,
I'm trying to break through to the next level of mathematical formulas for trackers by using 'if / and / or' functions. This is to calculate a price per kilogram for three categories -

if < 10kg = 10/kg (i.e. 3 x 10 = 30, or 7 x 10 = 70)
(so up to 9.9999)

if between 10kg and 20kg = 8/kg (i.e. 11 x 8 = 88, or 17 x 8 = 136)
(so from 10.0 - 19.999)

if > 20kg or greater = 6/kg (i.e. 22 x 6 = 132, or 33 x 6 = 198)

I was only able to create one possible formula for the first case, but it doesn't work ('f_289' is the numeric field for weight in kg)-

if (equals f_289 1 2 3 4 5 6 7 8 9 10f_289 10)

Is there a > or < function in Advance Rating?

Any help would be hugely appreciated,
Thanks
Mike