Thanks for all your help on this. I couldn't figure it out so I slept
on it and now I have it.
Here is the formula that worked.
=IF(AND(F9="A",G9119,G9<241),240,IF(AND(F9="B",G9 239,G9<481),480,""))
It changes throughout the sheet, but used this formula as the example
to just change numbers around.
The numbers used in A and B are the same except B goes up to 480.The
numbers go like this.
A B
15 15
30 30
60 60
120 120
240 240
480
I have it all figured out except for one part. Here are the 2 formulas
to combine like the previous one.
=IF(G9<240,"",240)
=IF(G9<480,"",480)
Here is what I came up with. Excel accepted the entry, but gives me
#VALUE! error.
=IF(AND(F9="A",G9<240),"",240),IF(AND(F9="B",G9<48 0),"",480)
On Tue, 8 Mar 2005 21:45:37 -0800, "Biff"
wrote:
Hi!
Note: in F9 I made a drop-down list so it can pick A or
B. Would that tamper with the formula?
No, that'll have no negative impact. The problem is that
the formula is not properly constructed.
I can't really see why you need to use A= this formula and
B= that formula unless A and B are related to specific and
separate criteria.
If you simply want to return different values based on the
value of G9, you could do this:
=IF(AND(G9119,G9<241),240,IF(AND(G9239,G9<481), 480,""))
But, if you do need to base things on F9 equalling either
A or B here are a couple of ideas:
=IF(AND(F9="A",G9119,G9<241),240,IF(AND
(F9="B",G9239,G9<481),480,""))
Using this formula, if F9=A and G9241 you'll get "". Not
sure that's what you want but that's how you're separate
formulas would have handled it.
Here's something that uses Jason's approach with a little
twist.
Create defined names for the 2 formulas:
A =IF(AND(G9119,G9<241),240,"")
B =IF(AND(G9239,G9<481),480,"")
Then use this formula:
=CHOOSE(MATCH(F9,{"A","B"},0),A,B)
This will work the same as the second formula I show above.
Biff
-----Original Message-----
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.
.
.
|