You said:
if this number in beginning inventory is less than the amount to be
used, then use it all, but if it is less than, only multiply the amount
needed.

I am hearing:

If BeginInventory is less than, do something, but if BeginInventory is
less than, then do something else.

Please try to clarify.


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=474553