Thread: Calculate a quantity rebate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sige
 
Posts: n/a
Default Calculate a quantity rebate
My solution looks like:

=IF(LOOKUP(B2;Rebates)<0;LOOKUP(B2;Rebates)*A2;LOO KUP(B2;Rebates))

Reply With QuoteReply With Quote