# Help with adding % criteria to a cell

#### =HPSF=RMP

##### Board Regular
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!!

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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
NOPQRST
1
201
320.9
430.8
540.7
6\$28.003\$22.40
7
Sheet4

Formula in P6

=LOOKUP(O6,R2:S5)*N6

Or in P6 try:

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

HTH

Tazguy37 said:
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.

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

HTH

Very cool!!!

Thanks so much!

Replies
5
Views
127
Replies
4
Views
254
Replies
1
Views
255
Replies
1
Views
290
Replies
6
Views
249

1,203,125
Messages
6,053,655
Members
444,676
Latest member
locapoca

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back