| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate percentage of two cells
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? |
|
#2
|
|||
|
|||
|
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? . |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? . |
|
#5
|
|||
|
|||
|
Thank you JE, it worked! I tried and tried but could not figure a resource
myself. I much appreciate your help. "JE McGimpsey" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forumla to calculate a percentage | Excel Discussion (Misc queries) | |||
| How do I calculate ratios between 2 cells? | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Excel 2003 -- I need to know how to calculate a percentage of uni. | Excel Discussion (Misc queries) | |||
| calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions | |||
Linear Mode
