0

This question already has an answer here:

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 Oct 10 at 12:30

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    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
1

Yes, there is a much simpler way to do what are you trying to do:

=INT(AC11/10)

Good luck!

  • I get an error that says INT only takes one argument and it reads the ,10 as a second argument: Yes, there is a much simpler way to do what are you trying to do: =INT(AC11,10) – ldavi00 Oct 9 at 18:56
  • Thank you again for the suggestion. I found the answer and used: =INT(AC11/10) – ldavi00 Oct 9 at 19:30

Not the answer you're looking for? Browse other questions tagged or ask your own question.