PING: Anyone who knows math/excel
 

Okay I won't lie, I am absurdly terrible at math and I am taking an Excel class right now. Basically I need to do a formula for sales commission and I am pretty sure I am fucking up.

My total price is $2438.39 and commision is 8.75%

Obviously this is easy for 90% of the world but for whatever reason I am stymied. What is the forumla for something like this?

Although you would be better off putting 0.0875 in another cell, then having your commission multiply the cell for total price by the cell with the 0.0875 in it, in case you want to change it to some other percentage.

I told you I was retarded. Never the less, I appreciate it.

Follow up - Is there a way format cells so they round up decimals?

just click on the cell you want to be the destination cell and type this....

=(click on the cell with the $$ in it)*.0875

there shouldn't be any parenthesis btw

A quick way to figure what your total price + commission would be to multiply 2438.39 x 1.0875

Just a "future reference" note.

And in the spirit of learning... the reasoning is...

T = base_price + commission
c = b * 0.0875
T = b + (b * 0.0875)
apply the distributive rule...
T = b * (1 + 0.0875)
T = b * 1.0875