Forum Discussion
Need help writing a formula
I need help writing formula for table below that will express the correct points when the number of hours is put into cell. Above 10=0 points, 8.0 to 9.9=2 points, 6.0 to 7.9=4 points, 5.0 to 5.9=6 ...
=IF(A1>=10,0,IF(A1>=8,2,IF(A1>=6,4,IF(A1>=5,6,8))))
Try this formula it should work!