Jun 26, 2018 03:36 PM
Hi Everyone,
IF({Weight per box}<25, - I need to use this price: $215+({Weight per box}-0.5)*64 IF({Weight per box}>25, I need to use this price: {Weight per box}*52
I’ve tried several time, but still can’t get it right, please let me know where I did wrong?
Thanks! Tomas
Jun 26, 2018 03:52 PM
Assuming {Weight per box} is a number field, you can use this:
{Weight per box}
IF( {Weight per box} < 25, 215 + ({Weight per box} - 0.5) * 64, {Weight per box} * 52 )
And then format that formula field as currency.