Thread: Show difference between tow numbers as a + or - value.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CWal CWal is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote