# 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,)
))))))))))))))))
``````

## marked as duplicate by John C, serenesat, Rubén google-sheets StackExchange.ready(function() { if (StackExchange.options.isMobile) return; \$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() { var \$hover = \$(this).addClass('hover-bound'), \$msg = \$hover.siblings('.dupe-hammer-message'); \$hover.hover( function() { \$hover.showInfoMessage('', { messageElement: \$msg.clone().show(), transient: false, position: { my: 'bottom left', at: 'top center', offsetTop: -7 }, dismissable: false, relativeToBody: true }); }, function() { StackExchange.helpers.removeMessages(); } ); }); }); Oct 10 at 12:30

• 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 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 at 16:29

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