In cell D5 I will be entering in a figure, in cell G5 I need to multiply it
by a percentage, the percentage changes depending on the value of cell D5. I
have 8 ranges to accomadate the 1st one being a less than and the last one
being a more than.

Is this enough information to get some assistance?
--
A.