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 ...
Or create a lookup table. I named it Points.
Formula in B2 is
=XLOOKUP(A2, Points[Threshold], Points[Points], "", -1)