View Single Post
  #4   Report Post  
Suzie
 
Posts: n/a
Default

Thank you Biff - I could have been years trying to figure it out! I tried
Help, my Excel book, etc. Much thanks.

"Biff" wrote:

Hi!

=(B2-ABS(B1))/ABS(B1)*100

Biff

-----Original Message-----
I paid $5 and netted $10 on a stock
Cell 2A has a number -5
Cell 2B has a number 10
Cell 2C - what formula would I put in this cell to

calculate the percentage
profit?
.