Thread: formula to show + or - before the result of an existing formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
  
Posts: 191
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.

Right now it just displays the whole # if positive and nothing if negative.

What I have =IF(B4/B3-100%0,B4/B3-100%,"")


Reply With QuoteReply With Quote