Here's one way:

=D8*IF(A2<=25,0.1,IF(A2<=50,0.2,IF(A2<=100,0.4,0.5 )))

If you decide to have more conditions, then you might consider a
lookup table.

You can use B4, B5, B6 etc in the formula instead of the actual values
I have posted.

Hope this helps.

Pete

On Oct 28, 1:19 am, JP wrote:
How can I create a formula for the following:

if A2 is <= 25 then * D8 by B4, and if A2 is <=25 but =50 then *D8 by B5,
and if A2 is<=50 but =100 then * D8 by B6?

So essentially if A2 is 0-25 then multiply D8 (a constant) by .10
and if A2 is 25-50, then multiply D8 by .2
and if A2 is 50-100, then multiply D8 by .4
and if A2 is 100-200, then multiply D8 by .5

Thanks for any help.

JP