requiring column entries

C

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.
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top