calculate missing data

  • Thread starter Thread starter Mux
  • Start date Start date
M

Mux

Hi there, I am trying to set up a formula where the missing data i
automatically calculated by excel.

ie. i got x amount of money for a stock trading at $y/share. I woul
like to know how many stocks i can buy for the money.

but!!

I would like to have the option to put the share price and see ho
much money i need to invest.

when trying to set up a reference formula i get circs all the time

is there a way to create a formula where excel finds me the missin
value (w/o using the solver or goal seek)?

thank
 
No problem at all, but just make sure you put your variables and formula in
different cells, eg:-

In cell A1 put the amount of money you have
In cell A2 put the price per share
In cell A3 put =INT(A1/A2) << You can have this many shares. The INT gets rid
of the decimals on the assumption that you can't have part of a share.

Now, if you have a target number of shares in say cell A5, and you want to know
how much it will cost you for those shares whilst they trade at the price in
cell A2, then in say A6 put =A5*A2 and this will be how much it will cost you.

Now, whilst I can help you with how to lay it out in a spreadsheet, what you
really need to do is understand the basic maths principles behind what we just
did, and also make sure you understand why you cannot have a formula that refers
to itself without getting a circular reference. It sounds very much like an
assignment question, and you honsetly don't do yourself any favours if you don't
spend a bit of time understanding the answer. If I'm way off base here then my
apologies, and good luck.
 
Back
Top