Formatting an IF Formula

[ttauscher]

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?

 

[jac3130]

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?

 

[jac3130]

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?

 

[ttauscher]

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.

 

[jac3130]

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