Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
requiring column entries
I have a spreadsheet that includes the following fields.
Item - Quantity - Price Each - Total Price The Total Price column is a calculated column that reflects the sum of the Quantity column times the Price Each column. However, some items do not require a quantity, but only requires a total price. For efficiency sake, users do not want to enter any more information than is required. So I didn't want to force them to enter a "quantity" of 1 plus put the price in "price each" in order to get the amount to reflect in the Total Price column. What is a good way to handle the items that don't require this extra quantity entry? If I allow the user to just enter Total Price they will permanently erase my formula. I'm wondering if there is a creative alternative. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
requiring column entries
I would allow them to leave quantity blank, but enter Price Each. Your Total
Price formula then becomes: =if(Quantity="",1,Quantity)*PriceEach Regards, Fred "Candace" wrote in message ... I have a spreadsheet that includes the following fields. Item - Quantity - Price Each - Total Price The Total Price column is a calculated column that reflects the sum of the Quantity column times the Price Each column. However, some items do not require a quantity, but only requires a total price. For efficiency sake, users do not want to enter any more information than is required. So I didn't want to force them to enter a "quantity" of 1 plus put the price in "price each" in order to get the amount to reflect in the Total Price column. What is a good way to handle the items that don't require this extra quantity entry? If I allow the user to just enter Total Price they will permanently erase my formula. I'm wondering if there is a creative alternative. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Problem requiring help | Excel Worksheet Functions | |||
Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
requiring a field | Excel Worksheet Functions | |||
Locking column entries to an adjacent linked column | Excel Discussion (Misc queries) |