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.
Best 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

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
Categories
Check out the Formula Handbook template!