Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to get multiple results of a cell?

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.