Working on a spread sheet for a golf tournament and I want to track hole in ones, eagles, birdies, pars, bogies, and double bogies. Just started messing around with the formula and was going to use "0" as par, "+1" for bogie etc. and then use the count function.
How do I write it to identify if a cells value is 1 less/greater than a cells value (instead of just <F3 or >F3)? Or can someone suggest a better route all together?
=IF(F5=F3,"0",IF(F5<F3,"-1",IF(F5>F3,"+1","")))
Bookmarks