Thread
:
Stock purchasing SS formula help needed.
View Single Post
#
3
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
Stock purchasing SS formula help needed.
=int(2000/.74)=2702
2702*.74 = 1999.48 for me
=int(2000/.74)*2702= 1999.48 for me
all this is with cells set to general format
--
paul
remove nospam for email addy!
"Madridbear" wrote:
Maybe a very basic point here but here goes.
I have £2000 to buy stock @£0.74 per item.
I am trying to make a formula that shows cost.
Example....
Money = £2000
Cost = £0.74
Units = 2702,702702702702.... Of course units come in whole amounts
so...
Units = 2702 (A. How can I make it average down to 2702)
Now, the second and most important problem I have.....
Total Cost = 2702*£0.74
BUT WHEN I DO THIS, it brings me back to £2000 instead of 1999.48.
How can I fix these issues?
Thanks
--
Madridbear
------------------------------------------------------------------------
Madridbear's Profile:
http://www.excelforum.com/member.php...o&userid=37645
View this thread:
http://www.excelforum.com/showthread...hreadid=572563
Reply With Quote
paul
View Public Profile
Find all posts by paul