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

by ldavi00   Last Updated October 09, 2019 16:03 PM - source

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)))))))))))))))))



Related Questions




Import range from 3 sheets/tabs into 4th

Updated February 06, 2019 12:03 PM

Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM