Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Julie Julie is offline
external usenet poster
 
Posts: 150
Default formula

I need to make a formula that if any item in column E is equal to any of the
items in column A then the quantity in column F(beside the item in E) needs
multiplied by the set price in column B(beside the item in A) example:

our set price list forecast sent to us
A B E F
15354792 .056 15418001 2000
15418001 .032 12129811 5000
12034476 .011