excel formula again

  Tony275 07:10 12 May 2007
Locked

Hi,
I asked a question about an Excel formula a couple of weeks back, And got several replies all very good, Except I struggle with excel So I decided in my wisdom, to go and try and find a ready made program that would do what I needed, Well basically I failed, So Here I am back cap in hand asking if anyone can help.
What I require is a Excel formula that in column A Date of purchase,column BItem Purchased,Column C Purchase Price,Column D Sale Date, Column E Sale Price, Column F profit or loss on that Item, and finally Column G Running profit / Loss on all Items.

If anyone Has a spare moment could they make a formula and send it to my via email I would be so grateful.
This as been a project that i have been trying to sort for so long.
But I just don't Understand Excel.

Hoping someone can help Tony

  VoG II 07:36 12 May 2007

Did this not help? click here

  Tony275 07:40 12 May 2007

VoG I know your the Top Man with excel and to anybody else it probably would have been fine, But I just don't seem to be able to get it to work,
And beleive me it's not for trying.

Many Thanks for your prompt responce Tony

  VoG II 07:55 12 May 2007

Please click my yellow envelope to send me a message. I'll send you an Excel file by return.

  Taff™ 08:06 12 May 2007

I`ve also got one I use for business already set up - probably won`t be as sophisticated as VoG`s but I`ll leave some random data in it so you can see how it works. Drop me a PM via the yellow envelope and I`ll send you an example. You can then compare the two and see which suits you.

  Tony275 08:16 12 May 2007

Many Thanks Vog and Taff

  Taff™ 08:47 12 May 2007

Example sent Note that my running profit and losses are shown in the total row at the bottom.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse's new logo: the trainer brand looks to its heritage for a fresh identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans échec ?