I need a conditional formula

[ltracy]

I am creating a master budget. I have worksheets and the first is m
input page. On one of the pages I have situation where if I have
large amount left in my finished goods inventory and the next period
don't need to use it all, I need to be able to have the columns adde
differently. Right now, it is set up so the first number is th
materials to be used, then the materials left in beginning inventor
are multiplied by the cost to give the cost of materials to be use
from beginning inventory. Well if I have 100 units in beginnin
inventory and I only need to produce 50, then I can't get an accurat
number because I don't know how to say if this number in beginnin
inventory is less than the amount to be used, then use it all, but i
it is less than, only multiply the amount needed

 

[Lilliabeth]

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.

 

[Bob Phillips]

Give an example in s/s layout.