View Single Post
  #4   Report Post  
Fat Bastard
 
Posts: n/a
Default

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.
.