# help with math formula please?

#### tspencer

##### Board Regular
I'm having trouble figuring out the correct formula to take 15% off a price in a cell.

My calculator says that \$11.95 - 15% is \$10.16
But when I do =(C2-15%) I get \$11.80

How do you make it subtract 15% instead of 15 cents?

Thanks for the help!

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### just_jon

##### Legend
=C2*0.85

Your formula is actually translating the 11.95 into 1195 percent, then subtracting 15% from it leaving 1180 percent, or 11.80

#### tspencer

##### Board Regular
Thank you. It works now but do you know why when I try and drag down that formula its not calculating the new price for each cell?

I have a row of prices to take 15% off of and its putting the same result in each cell.
\$11.95 \$10.16
\$11.95 \$10.16
\$9.95 \$10.16
\$22.95 \$10.16
\$9.95 \$10.16
\$16.95 \$10.16
\$15.95 \$10.16
\$7.95 \$10.16
\$12.45 \$10.16

#### just_jon

##### Legend
Do you have calculation set to Manual?

Click Tools | Options | Calculation tab, check Automatic

Or you can leave it as manual and use F9 to force calculation.

Or it may be you anchored your reference as in -- C\$2*.85

#### tspencer

##### Board Regular
Awesome. Thank you!

Replies
5
Views
142
Replies
3
Views
266
Replies
5
Views
214
Replies
6
Views
131
Replies
12
Views
179

1,195,665
Messages
6,011,026
Members
441,579
Latest member
satishrazdhan

### 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