View Single Post
  #1   Report Post  
anoop
 
Posts: n/a
Default hot to get + sign on positive nos


Dear all

Need quick help.

It is possible to get minus sign for negative nos.

But HOW CAN I GET PLUS '+' SIGN FOR POSITIVE CALCULATION.
E.G. SUBTRACT VALUE OF COL B FROM COL A and result should be +2


COL A COL B COL C
50 48 +2

if any body know how to do please reply soon.
Regards
Anoop


--
anoop
------------------------------------------------------------------------
anoop's Profile: http://www.excelforum.com/member.php...fo&userid=3066
View this thread: http://www.excelforum.com/showthread...hreadid=484757