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 ...
You can also use let to make your formula clean as below
=LET(x,A2,IF(x>=10,0,IF(x>=8,2,IF(x>=6,4,IF(x>=5,6,8)))))