Gain/Loss Calculator

[John Caines]

Hi All.

My maths has never been great
Just wondering if somone can help me out here,
Just looking for a simple calculator that can return % gain/loss, and value in £'s

Here's an example of layout of what the calculator would look like.
===============
Item xyz Values
Buy Price 0.07
Sell Price 7
Cost To Buy xyz £'s 1000

Total Bought Is?
% Gain Loss Is?
£'s Gain /Loss Is ?
===============

As an example I've entered 3 fields,
so cell B2 would say xyz buy price
Cell C2 would say sell price of xyz
and cell C2 is the total cost in £'s to buy (At the B2 buy price value).
So looking to auto calculate;
1. Total xyz amount bought (cell B6)
2. Total % gain/loss (Cell B7)
3. Total £'s gain/loss (Cell B8)


Hope someone can help me out here, I've been online in google for ages and ever calculator I've found does'nt seem to show what I'm after, always something missing

Hope someone can help me here.
Many thanks
A very frustrated
JC

 

[Marcílio_Lobão]

John Caines, Good morning.

I'm not sure if I understood well your necessity.

Take a lok at this small example I did for you.
https://www.sendspace.com/file/me7ad9

Please, tel us if it worked as you desire.
I hope it helps.

 

[John Caines]

John Caines, Good morning.

I'm not sure if I understood well your necessity.

Take a lok at this small example I did for you.
https://www.sendspace.com/file/me7ad9

Please, tel us if it worked as you desire.
I hope it helps.

Thanks a lotb for this Marcilio!!!
Works a treat!

Just what I was after!
Man,, so difficult working it out,,, but yes this is perfect.
Again many thanks!
A very thankful
John C

 

[Marcílio_Lobão]

John C,

I am very happy to have helped you.

Have a great Sunday!