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 Points, Below 4.9=8 Points
4 Replies
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)))))
Or create a lookup table. I named it Points.
Formula in B2 is
=XLOOKUP(A2, Points[Threshold], Points[Points], "", -1)
=IF(B3>=10,0,IF(B3>=8,2,IF(B3>=6,4,IF(B3>=5,6,8))))
=IF(A1>=10,0,IF(A1>=8,2,IF(A1>=6,4,IF(A1>=5,6,8))))
Try this formula it should work!
