I figured this out with the following formula.

=IF(C8>0.29,8,IF(C8>0.24,6,IF(C8>0.19,4,IF(C8>0,2," "))))