on 12-02-2016 1:41 PM
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vadim,
Excellent and thank you very much for breaking this. This is working for me and i can see the results as expected.
Also i will have to try the later formula """"[Red][<=-500](#,##0,);[>-500]#,##0,_)""""" as well.
Best Regards
Siddhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And you can also try this format without rounding at all:
[Red][<=-500](#,##0,);[>-500]#,##0,_)
It will show thousands, <=-500 will be red!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your prompt response Vadim. The formula is still showing me the negative value of ZERO.
=ROUND(EPMComparison(,D38,H38,I38),0)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
P.S. If you use formula:
=EPMComparison(,D38,H38,I38)
Use instead formula with rounding to integer:
=ROUND(EPMComparison(,D38,H38,I38),0)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Zero in red means that you have small negative number. Increase number of digits after decimal point and you will see it!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.