Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Please help me with Numbers formulas.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Shawn Koh" data-source="post: 1478457" data-attributes="member: 286184"><p><strong>Please help me with numbers formula - again</strong></p><p></p><p>Hi there, sorry for the double posts, after solving the previous thread on my own I encountered a far more difficult task.</p><p></p><p>Again, here is the spreadsheet I'm using.</p><p><img src="http://postimage.org/image/82v5byd11/" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>What i'm trying to achieve now is to generate a formula to calculate the shareholdings value of my stock based on the purchase price, in this case, "noble" under the shareholdings table.</p><p></p><p>based on the transactions here, in order to formulate the value i need to calculate it via taking the price multiplied by the quantity of that respective transaction, in this case, 10000*1.15 + 15000*1.13, after taking into account that some shares of that particular transactions have been sold.</p><p></p><p>I'm trying to automate this process, such that it calculates the respective value of the share based on the purchase price.</p><p></p><p>Can you help me generate a formula?</p><p></p><p>I have absolutely no idea how to tell it to search out the respective price and quantity it needs to calculate then sum it up. </p><p></p><p>I tried using lookup, vlookup, hlookup and still have no clue about how to go about.</p></blockquote><p></p>
[QUOTE="Shawn Koh, post: 1478457, member: 286184"] [b]Please help me with numbers formula - again[/b] Hi there, sorry for the double posts, after solving the previous thread on my own I encountered a far more difficult task. Again, here is the spreadsheet I'm using. [IMG]http://postimage.org/image/82v5byd11/[/IMG] What i'm trying to achieve now is to generate a formula to calculate the shareholdings value of my stock based on the purchase price, in this case, "noble" under the shareholdings table. based on the transactions here, in order to formulate the value i need to calculate it via taking the price multiplied by the quantity of that respective transaction, in this case, 10000*1.15 + 15000*1.13, after taking into account that some shares of that particular transactions have been sold. I'm trying to automate this process, such that it calculates the respective value of the share based on the purchase price. Can you help me generate a formula? I have absolutely no idea how to tell it to search out the respective price and quantity it needs to calculate then sum it up. I tried using lookup, vlookup, hlookup and still have no clue about how to go about. [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Please help me with Numbers formulas.
Top