Formula HELP... Display number only is formula results in less than ZERO

# of Contracted eDocs - # of Submitted eDocs = Need Contracting; IF the number is less than 0, I do not want a number to display in the Need Contracting field unless it is negative.


Tags:

Best Answer

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭
    Answer ✓

    Hi Danielle Maroon,

    Please use the below mentioned logic as per your cells.

    here, I have used IF condition, so if # of Contracted eDocs - # of Submitted eDocs< 0 then it will show blank otherwise it will calculate # of Contracted eDocs - # of Submitted eDocs = Need Contracting.

    =IF([Column34]4 - [Column34]5 < 0, "", [Column34]4 - [Column34]5)

    I Hope it will work for you !

    Thank You!

    Anjanesh Vaidya

Answers

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭
    Answer ✓

    Hi Danielle Maroon,

    Please use the below mentioned logic as per your cells.

    here, I have used IF condition, so if # of Contracted eDocs - # of Submitted eDocs< 0 then it will show blank otherwise it will calculate # of Contracted eDocs - # of Submitted eDocs = Need Contracting.

    =IF([Column34]4 - [Column34]5 < 0, "", [Column34]4 - [Column34]5)

    I Hope it will work for you !

    Thank You!

    Anjanesh Vaidya

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!