Show difference between tow numbers as a + or - value.
 

Hi,

I need to find a way of showing the difference between two numbers as a + or
- value. For example, showing the gains from a forecast number to an actual
number. Eg (A2 is forcaste number) "3", (B2 is actual number) "5", (C2 is
gain number) "+2". Or (A2 is forcaste number) "3", (B2 is actual number) "1",
(C2 is gain number) "-2".
--
Thanks, CWal

Show difference between tow numbers as a + or - value.
 

=IF(SIGN(B2-A2)=-1,"","+")&(B2-A2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"CWal" wrote in message
...
Hi,

I need to find a way of showing the difference between two numbers as a +
or
- value. For example, showing the gains from a forecast number to an
actual
number. Eg (A2 is forcaste number) "3", (B2 is actual number) "5", (C2 is
gain number) "+2". Or (A2 is forcaste number) "3", (B2 is actual number)
"1",
(C2 is gain number) "-2".
--
Thanks, CWal

Show difference between tow numbers as a + or - value.
 

On Jun 1, 8:50 am, CWal wrote:
Hi,

I need to find a way of showing the difference between two numbers as a + or
- value. For example, showing the gains from a forecast number to an actual
number. Eg (A2 is forcaste number) "3", (B2 is actual number) "5", (C2 is
gain number) "+2". Or (A2 is forcaste number) "3", (B2 is actual number) "1",
(C2 is gain number) "-2".
--
Thanks, CWal

Use this Custom format in the Column C cell...

-0;+0;0

Ken Johnson

Show difference between tow numbers as a + or - value.
 

Try custom format:

+#;-#;0
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"CWal" wrote in message
...
Hi,

I need to find a way of showing the difference between two numbers as a + or
- value. For example, showing the gains from a forecast number to an actual
number. Eg (A2 is forcaste number) "3", (B2 is actual number) "5", (C2 is
gain number) "+2". Or (A2 is forcaste number) "3", (B2 is actual number)
"1",
(C2 is gain number) "-2".
--
Thanks, CWal