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

Options

# 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:

• ✭✭✭✭✭
Options

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

Thanks,

Anjanesh Vaidya

Smartsheet Development, Ignatiuz Software

Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

• ✭✭✭✭✭
Options

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

Thanks,

Anjanesh Vaidya

Smartsheet Development, Ignatiuz Software

Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!