Referencing other cells
Hello,
Let me start by saying that I am not an Excel person. I am a
programmer, I know many languages, but I have never dabbled seriously
in Excel. With that said, a client recently asked for better way to
calculate his prices and a complete database-backed web application
would be overkill, so I want to try and offer an Excel solution.
Here's what I would like to do. The client makes all sorts of
pavements. He has a rate for jobs under 400 square feet and a another
rate for jobs above 400 square feet. I would like to be able to
define the types of pavements he does, along with their rates in a
Worksheet like so (I'm using the pipe '|' character to show the
different cells):
Pavement foo | 16 | 14
Pavement bar | 16 | 14
Pavement baz | 17 | 15
In the "main" worksheet, the client would choose the pavement he wants
(with a drop down list from Data - Validations), he would input the
number of square feet and Excel should return the total cost.
Example:
Pavement bar | 800 | =IF(A2 <= 400; REF(OtherSheet!
Column1LineOfPavement bar); REF(OtherSheet!Column2LineOfPavement bar))
Is that kind of manipulation possible?
Thanks,
Vincent.
|