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. |
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. |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com