# Conditional Percentage Calculations

#### dosman

##### New Member
I have a sheet with the following conditions

Cell I8 contains a validated drop down list which contains the numbers 1 through 9. Each number represents a percentage to be calculated.

Cell P8 contains a dollar amount I want to calculate a percentage for

I want cell Q8 to hold a formula that takes the number in I8 and uses the following rules to determine the percentage of the dollar amount in P8.
If the number in I8 = 1 then I need to calculate 100% of the total in P8
If it is 2 the percentage to be calculated is 90. 3 would be 80%, 4 would be 70% until you get to the number 9 which would be 20%.

I tried a simple IF statement in Q8 to test against one of the conditions and the formula keeps returning a date or the word False: IF(I8="4",P8*.7)

I am not sure if I am even using correct syntax for IF. I am wondering if there is a better function to use to match the number in I8 to calculate the corresponding percentage of the number in P8. Maybe a nested AND statement? Once I have a working function, the cell in Q8 needs to test for all 9 possibilities. I have started banging my head on the desk.

Any help is GREATLY appreciated.

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### DanteAmor

##### Well-known Member
Try:

=IF(I8=1,P8*1,IF(I8=2,P8*0.9,IF(I8=3,P8*0.8,IF(I8=4,P8*0.7,IF(I8=5,P8*0.6,IF(I8=6,P8*0.5,IF(I8=7,P8*0.4,IF(I8=8,P8*0.3,IF(I8=9,P8*0.2)))))))))

Or try this:

=P8*(1-((I8-1)/10))

Last edited:

Ignore

Last edited:

#### dosman

##### New Member
Thank you Dante and Stephen. This forum is absolutely amazing. All suggestions worked!!

You're welcome.

Replies
3
Views
150
Replies
7
Views
430
Replies
0
Views
240
Replies
3
Views
166
Replies
19
Views
720

Threads
1,195,949
Messages
6,012,478
Members
441,701
Latest member
vnkendijs

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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