# How to get multiple results of a cell? [closed]

What I'd like to achive is the following: I have a sheet that calculates the price of a certain item. It contains a lot of options, like what materials are used, what tools are used, etc in order to create the stuff, and there is a cell, which contains the amount, so I can calculate how much it will cost the client, if they order for example 1, 5 or any amount. It works fine, but I'd also like to have a little table, in which I could automaticly see the prices, if the amount is 1, 5, 20 and 50 (these are the usual request), without having to manually change the amount to the aforementioned numbers. So to sum things up, I'd like a function or something, that gets the result of cell 'B' (the final price), if cell 'A' (the amount) is 1, 5, 20 and 50.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by szubzerus close date 2017-10-17 08:41:58.012530

Sort by » oldest newest most voted
more

Thanks Mike, multiple operations was exactly what I was looking for! Worked like a charm :D

( 2017-10-12 20:14:25 +0100 )edit

The normal way is to enter the amounts in 4 different cells, for example, A1 through A4. Then calculate the final result in B1 based on A1.

Use absolute referencing in B1 for all cells except A1. For example, if tools are always listed in cell G8, then reference it as $G$8.

Then drag to fill the formula down from B1 to B4.

more

Hi Jim and thanks for the answer! Though it did not really solve my problem, so let me specify it a bit more. The price calculator sheet looks something like this:

Amount: 5
… cost of used material: 120
… preparation: 300
… work: 240

Final price: 660

So the final price is the sum of the three above. What I'm looking for is like a function, that puts a certain number in the amount cell, and returns with the final price cell, without actually changing them.

( 2017-10-12 19:54:44 +0100 )edit