How to insert =IF () - Formula result is a negative

Options

Hello all,

can someone help me fix this formula so that the result is zero or higher? i.e. no negative results.

=([Delivery to Site]@row - [Warehouse Storage Starts]@row) * 20

The formula calculates cargo unpack date versus delivery date, plus free storage time, then adds storage cost.

I've tried to add a IF statement but keep getting #UNPARSEABLE

Thanks

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Sorry, I forgot the leading square bracket in Delivery to Site

    =IF([Delivery to site]@row - [Warehouse Storage Starts]@row > 0, ([Delivery to site]@row - [Warehouse Storage Starts]@row) * 20, 0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!