# Is there a better way or more efficient way to write this IF statement? [duplicate]

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(AC11<150,14,
IF(AC11<160,15,)
))))))))))))))))
``````
• Checkout `IFS` on the Google Sheets Function List.If you need further help add a brief description of your search/research efforts as is suggested on How to Ask. By the way, looking for "better ways" usually is subjective. Please describe what means better in this case (improved readability, shorter formula...) – Rubén Oct 9 '19 at 15:54
• Thank you. Is there a improved way to create the following function in google sheets: =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(AC11<150,14,IF(AC11<160,15))))))))))))))))) – ldavi00 Oct 9 '19 at 16:29

``````=INT(AC11/10)