Loading...
 
Features / Usability

Features / Usability


help with advanced formula

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


Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.