How do i create a value for check boxes or option boxes

T

Tim wr

I am trying to create a sales quote form with multiple options available. I
would like to be able to click on an option and price of that option go into
the total for the product.
 
D

Dave Peterson

I would think you'd need to enter the quantity--especially if the customer can
ask for more than one of any item.

If that sounds reasonable, you could use a few columns:

Qty PartNumber Description UnitPrice ExtendedPrice

That 5th column could have a formula like:
=if(a2="","",a2*d2)

And you could use:
=sum(d2:Dxx)
to get the total price.
 
Top