Forum Discussion
Katelyn Ramsay
Dec 01, 2017Copper Contributor
Finding the Right Excel Function
Hello,
We have a work contest this month and I would like to create a spreadsheet to track my progress and my competition.
We earn one point for our daily goal of 6, then 1 more point p...
Detlef_Lewin
Dec 01, 2017Silver Contributor
Katelyn,
a more advanced solution:
=MAX(0,A1-6+(A1>=6))