On Tue, 26 Jan 2010 14:34:05 -0800, Andmor
wrote:

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?

Try this formula in cell G5:

=D5*VLOOKUP(D5,{-99999,1;10,2;20,3;30,4;40,5;50,6;60,7;70,8},2)/100

-99999 should just be a number less than then smallest possible value
in D5.

10,20,30,40,50,60,and 70 are the limit for the ranges.
Change them to suit your needs.

1,2,3,4,5,6,7, and 8 are the respective percentages.
Change them to suit your needs.

Example: If D5 is 34 the percentage is 4 and the result in cell G5
will be 1.36 (which is 4% of 34).

Hope this helps / Lars-Åke