Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock purchasing SS formula help needed.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock purchasing SS formula help needed.
=INT(A1/B1) or =ROUNDDOWN(A1/B1,0)
where A1=2000 B1=0.74 For total cost, format cell to Currency (or Decimal) with 2 decimal places HTH "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock purchasing SS formula help needed.
Supposing 2702.702703 is in cell A3 you should use =FLOOR(A3,1) that will result in 2702 that can be multiplied by 0.74 to give 1999.48 -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=572563 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF-THEN Formula help needed | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
Formula Help Needed | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Multipart formula needed | Excel Worksheet Functions |