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 ---
-- removed inline image ---