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

Danielle Maroon

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

Anjanesh Vaidya

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

Anjanesh Vaidya

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