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: 1478418" data-attributes="member: 286184"><p>Hello there, I'm trying to create a spreadsheet for my shares portfolio.</p><p></p><p>Currently, this is what I have.</p><p><img src="http://postimage.org/image/q04svducr/" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>What I'm trying to do, is to generate a formula to tell me how much shares I'm currently holding of "noble". I need it to look under the "transactions" table and calculate how much shares im currently holding.</p><p></p><p>I've been experimenting with lookup but can't seem to get it to get what I want as there are two conditions, that the share must be "noble" and that the transaction must be "buy" before it can add and the sure must be "noble" and that the transaction must be "sell" before it can minus.</p><p></p><p>Could anyone please help me out here?</p></blockquote><p></p>
[QUOTE="Shawn Koh, post: 1478418, member: 286184"] Hello there, I'm trying to create a spreadsheet for my shares portfolio. Currently, this is what I have. [IMG]http://postimage.org/image/q04svducr/[/IMG] What I'm trying to do, is to generate a formula to tell me how much shares I'm currently holding of "noble". I need it to look under the "transactions" table and calculate how much shares im currently holding. I've been experimenting with lookup but can't seem to get it to get what I want as there are two conditions, that the share must be "noble" and that the transaction must be "buy" before it can add and the sure must be "noble" and that the transaction must be "sell" before it can minus. Could anyone please help me out here? [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Please help me with Numbers formulas.
Top