Help

Please help for the IF Formula

881 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tomas
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

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.