Hi,
I have a logbook that I am using to keep track of investments. I have found a formula that calculates the Profit/Loss, but it requires me to manually select the Cost value in the Profit/Loss formula for it to work. I would like to know if there is a way to automate this so that it automatically selects the Cost value. I don't know how well I can explain what I am trying to do, but I have uploaded a sample of my workbook.
Regards,
Sam
Try this in I2, copied down...
=IF(G2>0,(G2*C2)-VLOOKUP(B2,$B$2:H2,7,0),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you, this looks like it's doing what I want it to do!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks