| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto populated price multiplied by quantity?
Amazing!!! Thank you so much!!!
"barry houdini" wrote: Hello Lindsay If you want the price column to show the price for a single item when quantity is blank....but then use the relevant quantity when quantity column is populated change your formula to =VLOOKUP(B5,X$5:Y$33,2,0)*IF(H5="",1,H5) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| supply chart with names on price or quantity | Charts and Charting in Excel | |||
| auto enter date when another cell populated? | New Users to Excel | |||
| Template Taxable / Non-taxable function, add quantity/price per | Excel Worksheet Functions | |||
| calculate price * quantity = total amount in a row of excel forml. | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
Hybrid Mode
