=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