0

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,)
))))))))))))))))
| improve this 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 '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
1

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

=INT(AC11/10)

Good luck!

| improve this answer | |
  • 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 '19 at 18:56
  • Thank you again for the suggestion. I found the answer and used: =INT(AC11/10) – ldavi00 Oct 9 '19 at 19:30

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