Forum Discussion

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.xlsx18 KB

excel

L Ducharme

Copper Contributor

Oct 05, 2017

I got a #Name? error.

Please advise.

Lynne

Detlef_Lewin

Silver Contributor

Oct 05, 2017

My advice is: Get the lastest subscription of Office365.

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