21,1,IF(O11<75>5">

How do I get this formula to increment by 1 per 25?

by ldavi00   Last Updated October 09, 2019 17:03 PM

I need my formula to increase by "1" for every "25". I wrote the following formula, but it does not work:

=SUM(IF(O11<25,0,IF(O11<50>21,1,IF(O11<75>51,2,IF(O11<100>76,3,IF(O11<125>101,4))))))

Tags : google-sheets


Related Questions


Updated March 03, 2018 02:03 AM

Updated September 20, 2019 15:03 PM

Updated September 19, 2018 13:03 PM

Updated June 10, 2019 17:03 PM

Updated July 26, 2018 21:03 PM