Ups, due to the bad quality of your format setting picture I didn't understand that you show thousands!
Then you have to round to thousands:
=ROUND(EPMComparison(,D38,H38,I38),-3)
Zero in red means that you have small negative number. Increase number of digits after decimal point and you will see it!
P.S. If you use formula:
=EPMComparison(,D38,H38,I38)
Use instead formula with rounding to integer:
=ROUND(EPMComparison(,D38,H38,I38),0)
And you can also try this format without rounding at all:
[Red][<=-500](#,##0,);[>-500]#,##0,_)
It will show thousands, <=-500 will be red!
Add comment