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

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



Adding missing dates to Google Sheets

Updated September 20, 2019 15:03 PM



Copying values between google sheets

Updated July 26, 2018 21:03 PM