Assign a $$ amount to a number and multiply

[pberg23]

I am not sure of what function to use. I need to assign different amounts to the # of pages in column C depending on that number, and then multiply that by the # of copies printed in column B to get the total price of a printed bill. I tried the LOOKUP function, but get an error. Can you get me on the right path?


-- removed inline image ---

 

[Oeldere]

c1=a1*b1 and drag down.

 

[Newport Count]

Hi pberg23,

This site should give you the answer: How to Use VLOOKUP’s Range Lookup Feature

You'll need to set up a min and max value table (for the different amounts) for your vlookup to reference and use the TRUE function rather than FALSE

Hope that helps.


Cheers,
Rich

 

[pberg23]

That is great help, I hadn't used a VLOOKUP before. THANKS!!