requiring column entries

[Candace]

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.

 

[Fred Smith]

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