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

[CWal]

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

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[Ken Johnson]

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

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

-0;+0;0

Ken Johnson

 

[RagDyeR]

Try custom format:

+#;-#;0
--

HTH,

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


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