I have the following formula: =AVERAGE(C8:GY8)-35, but I want to add that when a cell shows a negative number, i.e. -2, that the cell should show 0. This is a generic golf handicap formula, and I want the lowest handicap a person can have to be zero. I've tried numerous functions; ROUND, ROUNDUP, IF, but cannot get the formula to work. What can I add to my formula to get the desired result?
Solved by O. E. in 19 mins