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 hcp and ended with a 42 hcp.  (Golf is a tough game!). 

 

How can I show this person their status at the end of the year?

 

Thanks in advance for your superior knowledge!!

Lynne

excel

3 Replies

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Oct 05, 2017

        My advice is: Get the lastest subscription of Office365.

         

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

Resources