Forum Discussion

L Ducharme's avatar
L Ducharme
Copper Contributor
Oct 03, 2017

Plus or Minus formula

Hi.  I'm working on our 2018 golf stats report.  Please refer to cell u29.  I would like to show a plus or minus from the start of the season to the end of the season.  This person started with a 40 ...
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 03, 2017

Lynne,

 

one of many ways:

=SWITCH(SIGN(U28-U8),-1,"-",0,"+-",1,"+")
  • L Ducharme's avatar
    L Ducharme
    Copper Contributor
    Oct 04, 2017
    I got a #Name? error.

    Please advise.

    Lynne
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Oct 04, 2017

      My advice is: Get the lastest subscription of Office365.

       

      =CHOOSE(SIGN(U28-U8)+2,"-","+-","+")