How do i use the formula while taking a margin of items

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

Yes, Yes, Hu hu...it is working well!
Thank you very much @Fotis

Originally Posted by Fotis1991

Try

=ABS(1-(B2/A2))

What if Cost in A2 is 10, and Sale in B2 is 5. Your formula return 50% instead of -50%

Mr. fotis I need your explanation about Teethless mama's question..pls dear.
Alagarsamy

Originally Posted by Fotis1991

What kind of explanation? Pls, tell me what is this that you want to explain? I think question was clear and my answer too.

As Teethless said, I have got a below confusion with taking margin; details given below;
An example: As a distributors MARGIN means it is our profit, if we buy one pen with 10$ and we will sale with $20 so our profit margin we took 100%, but if we buy one pen with $10 and we sale with $5 that means we lost 50% profit, so the margin should be in negative. Am i correct?
If yes, please provide the formula to finish the thread.

Thanks,
Samy

Ya, its working well,
Thank you very much.