obviously those of you with more attention will notice "what the fuck are you doing with <=0.25 followed by >=0.25??
=IF(G6<0.25,1,IF(AND(G6 >0.25, G6<=0.49),2,IF(AND(G6 >=0.49, G6<=0.74),3,IF(G6>=0.75,4,0))))
You could make that a lot neater with an IFS =IFS(G6<0.25,1,G6<0.5,2,G6<0.75,3,G6<=1,4)
@Chalfie started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
obviously those of you with more attention will notice "what the fuck are you doing with <=0.25 followed by >=0.25??
=IF(G6<0.25,1,IF(AND(G6 >0.25, G6<=0.49),2,IF(AND(G6 >=0.49, G6<=0.74),3,IF(G6>=0.75,4,0))))