Barb,
If I understand you correctly then with your table, Model, Price & Copies
in A1:C5 and the required model # in E1 then:
=VLOOKUP(E1,A1:C5,2)*VLOOKUP(E1,A1:C5,3)
will give the total price for the model.
HTH
Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk
"Barb1" wrote in message
...
I have 4 copiers with different prices per copy. I need to write a
formula
with criteria to fit this.
Model Price per copy number of copies total price
490 .012 17
550 .32 211
So, I need if model #x then multiply by its corresponding cost.
|