Please help for the IF Formula


#1

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


#2

Assuming {Weight per box} is a number field, you can use this:

IF(
   {Weight per box} < 25,
   215 + ({Weight per box} - 0.5) * 64,
   {Weight per box} * 52
)

And then format that formula field as currency.