on 2007 Jul 11 4:34 PM
Hello Friends,
I have one KF which sometimes reflect negative and sometimes positive.
What should be the syntax of formula to have positive as negative and negative as positive.
I have already tried reverse sign, but that only helps to display that formula.
when I am using this formula in any other formula it is taking original sign of KF.
Please Help.
Thanks,
John.
Hi John,
Just multiply it by -1. If it is negative, it will become positive and vice versa.
Hope this helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.