Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need a conditional formula
I am creating a master budget. I have worksheets and the first is my input page. On one of the pages I have situation where if I have a large amount left in my finished goods inventory and the next period I don't need to use it all, I need to be able to have the columns added differently. Right now, it is set up so the first number is the materials to be used, then the materials left in beginning inventory are multiplied by the cost to give the cost of materials to be used from beginning inventory. Well if I have 100 units in beginning inventory and I only need to produce 50, then I can't get an accurate number because I don't know how to say 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. -- ltracy ------------------------------------------------------------------------ ltracy's Profile: http://www.excelforum.com/member.php...o&userid=27952 View this thread: http://www.excelforum.com/showthread...hreadid=474553 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Give an example in s/s layout.
-- HTH Bob Phillips "ltracy" wrote in message ... I am creating a master budget. I have worksheets and the first is my input page. On one of the pages I have situation where if I have a large amount left in my finished goods inventory and the next period I don't need to use it all, I need to be able to have the columns added differently. Right now, it is set up so the first number is the materials to be used, then the materials left in beginning inventory are multiplied by the cost to give the cost of materials to be used from beginning inventory. Well if I have 100 units in beginning inventory and I only need to produce 50, then I can't get an accurate number because I don't know how to say 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. -- ltracy ------------------------------------------------------------------------ ltracy's Profile: http://www.excelforum.com/member.php...o&userid=27952 View this thread: http://www.excelforum.com/showthread...hreadid=474553 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formula | Excel Worksheet Functions | |||
Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
Using a Formula in a Conditional Statement? | Excel Worksheet Functions | |||
conditional formatting formula | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |