Ask Your Question

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

asked 2017-10-12 14:26:08 +0200

szubzerus gravatar image

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 flag offensive 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

2 Answers

Sort by » oldest newest most voted

answered 2017-10-12 19:57:46 +0200

Mike Kaganski gravatar image

updated 2017-10-12 19:59:50 +0200

edit flag offensive delete link more


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

szubzerus gravatar imageszubzerus ( 2017-10-12 20:14:25 +0200 )edit

answered 2017-10-12 17:35:45 +0200

Jim K gravatar image

updated 2017-10-12 17:37:17 +0200

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.

edit flag offensive delete link 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.

szubzerus gravatar imageszubzerus ( 2017-10-12 19:54:44 +0200 )edit

Question Tools

1 follower


Asked: 2017-10-12 14:26:08 +0200

Seen: 28 times

Last updated: Oct 12