Thread: auto populated price multiplied by quantity?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
  
Posts: 57
Default auto populated price multiplied by quantity?
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 With QuoteReply With Quote