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

=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
>
>

=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
[email protected]
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
>
>