Skip to main content

Please help for the IF Formula

  • June 26, 2018
  • 1 reply
  • 15 views
T

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

    This topic has been closed for replies.

    1 reply

    J
    Forum|alt.badge.img+18

    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.

      Terms & ConditionsAccessibility statement