Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 10th 06, 01:05 PM posted to microsoft.public.excel.worksheet.functions
ivoryhunter
 
Posts: n/a
Default plus and minus sign in cells


Hi,
I think this is an easy one but beyond me! How can I format the cell
to show the result of a sum as a plus or minus (or positive and
negative)? It shows minus values by default but I cannot get it to
show a plus sign. I have tried the Format Cells/custom part with no
joy. example:

Cell B8 = 3
Cell C8 = 2

=SUM(B8-C8) gives me a "1" in cell D8, but I want it to show "+1"

and

Cell B11 = 4
Cell C11 = 5

=SUM(B8-C8) gives me a "-1" in cell D8, which is correct, however I
want this to appear in red


Grateful for any assistance.

Thank you.


--
ivoryhunter
------------------------------------------------------------------------
ivoryhunter's Profile: http://www.excelforum.com/member.php...o&userid=33327
View this thread: http://www.excelforum.com/showthread...hreadid=531492


  #2   Report Post  
Old April 10th 06, 01:15 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default plus and minus sign in cells

Something like

+#,##0;[Red]-#,##0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ivoryhunter"
wrote in message
...

Hi,
I think this is an easy one but beyond me! How can I format the cell
to show the result of a sum as a plus or minus (or positive and
negative)? It shows minus values by default but I cannot get it to
show a plus sign. I have tried the Format Cells/custom part with no
joy. example:

Cell B8 = 3
Cell C8 = 2

=SUM(B8-C8) gives me a "1" in cell D8, but I want it to show "+1"

and

Cell B11 = 4
Cell C11 = 5

=SUM(B8-C8) gives me a "-1" in cell D8, which is correct, however I
want this to appear in red


Grateful for any assistance.

Thank you.


--
ivoryhunter
------------------------------------------------------------------------
ivoryhunter's Profile:

http://www.excelforum.com/member.php...o&userid=33327
View this thread: http://www.excelforum.com/showthread...hreadid=531492



  #3   Report Post  
Old April 10th 06, 01:17 PM posted to microsoft.public.excel.worksheet.functions
Scoops
 
Posts: n/a
Default plus and minus sign in cells

Hi ivoryhunter (not very PC)

In Custom format:

+#,##0;[Red]-#,##0

Regards

Steve

  #4   Report Post  
Old April 10th 06, 01:28 PM posted to microsoft.public.excel.worksheet.functions
ivoryhunter
 
Posts: n/a
Default plus and minus sign in cells


Thanks Bob and Steve.

Bob - this is spot on - thank you.


--
ivoryhunter
------------------------------------------------------------------------
ivoryhunter's Profile: http://www.excelforum.com/member.php...o&userid=33327
View this thread: http://www.excelforum.com/showthread...hreadid=531492



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017