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