Help with adding % criteria to a cell

[=HPSF=RMP]

Hello again,
I'm needing to do the following and would appreciate the help.

Here is my attempt.
=IF[((o6<"2",(n6*1)),IF((o6="2",(n6*.9))IF((o6="3" ,(n6*.8))(IFo6>"3" ,(n6*.7))]

Obviously my attempt is way off base.
This is what i'm trying to do.

Cell O6 is an empty field. A number from 1 to 10 will be entered.
Cell N6 is a data field that has a total dollar figure.
Cell P6 is the cell the formula needs to be in. (adjusted dollar figure)

I'm wanting to be able to put a number from 1-10 into Cell O6. I then want Cell P6 to read the number entered into O6 & N6, then do the following.

If the number is <2 multiply Cell N6 by 1 and enter new $ total in P6
If the number is 2, multiply Cell N6 by .9 and enter new $ figure in P6
If the number is 3, multiply Cell N6 by .8 and enter new $ figure in P6
If the number is 4 or greater, multiply cell N6 by .7 and enter new $ figure in P6.

I hope I explained it so all can understand.

Thanks for any help!!

 

[barry houdini]

There are several ways you could do this but the best approach is probably to construct a small table showing your possible values and resulting multiplier.

Book1
	N	O	P	Q	R	S	T
1
2					0	1
3					2	0.9
4					3	0.8
5					4	0.7
6	$28.00	3	$22.40
7
Sheet4

Formula in P6

=LOOKUP(O6,R2:S5)*N6

 

[Tazguy37]

Or in P6 try:

=N6*LOOKUP(O6,{1,2,3,4},{1,0.9,0.8,0.7})

HTH

 

[=HPSF=RMP]

Or in P6 try:

=N6*LOOKUP(O6,{1,2,3,4},{1,0.9,0.8,0.7})

HTH

Thanks to both of you!
This one is probably better for me because I would have to hide the table.

I forgot to add one other item. Is there a way to bypass the forumla and use the whole dollar figure if cell O6 is blank?

The majority would be blank. The 1-10 would be exceptions.

 

[Tazguy37]

Only a slight adjustment:

=N6*LOOKUP(O6,{0,1,2,3,4},{1,1,0.9,0.8,0.7})

HTH

 

[=HPSF=RMP]

Very cool!!!

Thanks so much!