Im tring to calculate the percentage of stock loss.
In Cell A1 i have $50,000
In Cell A2 i have $5,000 loss leaving me $45,000
In Cell A3 i want to know the percent i have lost.
Any help?
Thanks guys
Im tring to calculate the percentage of stock loss.
In Cell A1 i have $50,000
In Cell A2 i have $5,000 loss leaving me $45,000
In Cell A3 i want to know the percent i have lost.
Any help?
Thanks guys
Last edited by J Glanton; 11-12-2011 at 02:51 PM.
=(A2/A1)*100 formatted as percentage.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks TM
appreciate it
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Will Do
Thanks for the info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks