View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=-(B2/A2+1)

Format as a %age.

In article ,
"Suzie" wrote:

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?