# Formatting an IF Formula

#### ttauscher

##### New Member
How do I write a formula to calculate % of a benchmark? Example for a benchmark of \$100. If this month my cost is \$107 (+7%) and next it is \$98 (-2%). How do I express the formula?

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Take your monthly cost and subtract from it the benchmark. In the first example, this would be 107 - 100 = 7. Then divide by the benchmark of 100 = 0.07 = 7%. What else do you need it to do?

Subtract your benchmark from your monthly cost and then divide by the benchmark. For instance, 107 - 100 = 7 / 100 = 0.07 = 7%. What else do you need it to do?

Thanks, I know how to do the math. I am new to Excel and was wanting to know how to write a formula so every time I enter new data, it will tell me how far I am off my benchmark.

<FORM id=aspnetForm method=post name=aspnetForm action=http://office.microsoft.com/en-us/excel-help/cell-function-HP010062392.aspx>Benchmark = A1
Monthly Cost = B1
Difference = C1

The formula in C1 would be =(B1-A1)/A1

</FORM>Then you can just copy it down.

Replies
7
Views
235
Replies
4
Views
250
Replies
0
Views
305
Replies
3
Views
147
Replies
7
Views
129

1,196,250
Messages
6,014,236
Members
441,808
Latest member
xplainer

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