Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. Tim wr wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List Box Multi Select Option | Excel Worksheet Functions | |||
How do i create option Boxes for a survey on excel?? | Excel Discussion (Misc queries) | |||
how to create event boxes in excel | Excel Discussion (Misc queries) | |||
how to create event boxes in excel | New Users to Excel | |||
How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) |