- 1,174
- Phoenix, AZ
- MonyB
I just started entering the data for the sheet and noticed that there was no formula for the avg variation field. If you follow @OJBrit's template and use column K for the variation and column L for the points the following formula should work all the way up to a variation of -15:
=if(K2<-14, 4, if(K2<-9, 3, if(K2<-4, 2, if(K2<0, 1,if(K2>0, -1, 0)))))
=if(K2<-14, 4, if(K2<-9, 3, if(K2<-4, 2, if(K2<0, 1,if(K2>0, -1, 0)))))
Last edited: