How to use a list of values with one calculation.

[elliot.borst]

Hi folks, looking for assistance for the masters please.

I have a 2 sheet spreadsheet.

On sheet 2 there is a little calculator that you put a number into cell A2 for example the number 2335 and it calculates a price from a set scales prices.

The number inserted represents sales of an item in a month.

We sell those with different scales rates depending on qty.

For example for 1 to 150 is $4 per item, then 151 to 300 are $3 per item and so on.

The calculater works just fine and outputs the results into cell B2.

Now, on Sheet 1, I have a simple list of customers in Column A and their monthly qty in column B.

I would like to have their calculated price in column C without having to copy and paste each of their qty into sheet 2 and then copy the result back.

Hope that makes sense, much appreciated for your time.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.