Try something like this:

=H10*CHOOSE(E10+1,1,0.15,0.22,0.5)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"j5b9" wrote:

I hope some one can help me... I'm been trying to get this to work for 5 days
now!!! HELP!!!! LOL

I need a formula that I copy and paste into a cell down a spread sheet Not
using a macro or pivot table. I dont know how to set them up.


In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3)
Nothing entered is = No change to any cells
1 is to .15 % increase
2 is to = .22 %
3 is to = .5 %

Then a cell that will take that % and Multiply another cell into a 3rd cell.

E10*H10 = I10 total