View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default formula to show + or - before the result of an existing formula

I need a formula that will display + or - in front of the value of my
current formula.

B4=7.5 B3=6.5

I want the result to display +15% or - if that were applicable.


One way is to use two steps.

First, use the formula:
=IF(B3=0,"-",B4/B3-100%)
(Notice the added check for dividing by zero.)

Second, select the cell holding the formula and use:
Format Cells Number Custom
and in the Type field put
+0%;-0%