Dear Sir,
I am making price list for more than 100 items in excel 2010 version, Can any one tell me the formula for taking margin for those items, details given below;
An example: cost A2 = $10, selling price B2 = $20, margin C2 = ? so i need the margin for this?
Currently i am using this formula =1-(B2/A2)
=1-($20/$10) the answer is -100%, my problem is that the margin is appearing in minus but i need the margin in plus (i.e. 100%)

please provide me the correct formula to do that.

Yours sincerely,
Alagarsamy