Forum Discussion
Hill101902
Jan 22, 2025Copper Contributor
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 ...
Milan
Jan 23, 2025Copper Contributor
=IF(B3>=10,0,IF(B3>=8,2,IF(B3>=6,4,IF(B3>=5,6,8))))