Is there a better way or more efficient way to write this IF statement?

Published: 10/10/2019
Is there a better way or more efficient way to write this IF statement?
Source: WEBAPPS.STACKEXCHANGE.COM

I need a way to get the return number to increase by "1" after every increment of "10". Is there a more efficient way to do this other than: =SUM( IF(AC11<10,0, IF(AC11<20,1, IF(AC11<30,2, IF(AC11<40,3, IF(AC11<50,4, IF(AC11<60,5, IF(AC11<70,6, IF(AC11<80,7, IF(AC11<90,8, IF(AC11<100,9, IF(AC11<110,10, IF(AC11<120,11, IF(AC11<130,12, IF(AC11<140,13, IF

Read more
Related news
Comment
FACEBOOK