Thanks for the responses.
Here is a more specific example of what I am doing.
Here are the 2 formulas I have.
=IF(AND(G9119,G9<241),240,"")
=IF(AND(G9239,G9<481),480,"")
If I put A in F9 it will use the first one and B in F9 will use the
second one.
Here is what I made based on the suggestion below. Excel didn't want
to accept it.
Note: I use a word instead of A or B.
=IF(F9="B",(AND(G9239,G9<481),480,""),IF(F9="A",( AND(G9119,G9<241),240,""))
Note: in F9 I made a drop-down list so it can pick A or B. Would that
tamper with the formula?
On Tue, 8 Mar 2005 11:04:08 -0800, "Biff"
wrote:
Hi!
Try something like this as long as you only have 2 or 3
conditions:
=IF(F9="A",SUM(A1:A5),IF(F9="B",AVERAGE(A1:A5), IF
(F9="C",MIN(A1:A5),"")))
A = sum the range
B = average the range
C = minimum value in the range
Experiment!
Biff
-----Original Message-----
I am not knowledgable in Excel and I am trying to figure
out how to do
something.
I want some cells in a row to choose between 2 or 3
formulas based on
the value I enter for a certain cell in the same row.
For example: If I enter "A" in F9 it would use Formula A
in X9, AC9,
etc. If I enter "B" in F9 it would use Formula B in X9,
AC9, etc.
How would I do this? I am not even sure of the
terminology of the
solution to research it. Variable, IF, ???????
Thanks.
.
|