IF Statements

Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an individuals goal
and actual result, but I need to have approx. 60 IF
statements in order to do this. Does anyone know of any
way to accomplish this? Any help would be greatly
appreciated! Thanks!

Bill go look at Chip Pearson's work around

Gilles Desjardins
www.CPEARSON.COM

"Bill" wrote in message
...
Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an individuals goal
and actual result, but I need to have approx. 60 IF
statements in order to do this. Does anyone know of any
way to accomplish this? Any help would be greatly
appreciated! Thanks!

Bill,

You'll need to use a VLookup.
Take a look in Excel help for some pointers.
If you can't get it to work, post back here with how
your data is laid out in the workbook and someone
will surely be able to help you with it.

John

"Bill" wrote in message
...
Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an individuals goal
and actual result, but I need to have approx. 60 IF
statements in order to do this. Does anyone know of any
way to accomplish this? Any help would be greatly
appreciated! Thanks!

Bill, you "shouldn't" need to use more than a few IF statements to do a job,
there is another way.

If you'd like specific guidance from people in this arena, give some
examples of what your data looks like, what you want to accomplish, and what
result the formula should give.



"Bill" wrote in message
...
Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an individuals goal
and actual result, but I need to have approx. 60 IF
statements in order to do this. Does anyone know of any
way to accomplish this? Any help would be greatly
appreciated! Thanks!

Gilles,

With about 60 IF's (per the OP), that would probably be
more trouble than it's worth (and a nightmare to debug).

John

"Gilles Desjardins" wrote in message
...
Bill go look at Chip Pearson's work around

Gilles Desjardins
www.CPEARSON.COM

"Bill" wrote in message
...
Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an individuals goal
and actual result, but I need to have approx. 60 IF
statements in order to do this. Does anyone know of any
way to accomplish this? Any help would be greatly
appreciated! Thanks!

Bill,

I get the impression that you have your scores laid
out across row #7 ????
You can't do a vlookup that way.
For a vlookup, you should have at least two columns.
The leftmost being the values that you're looking up
and the colum(s) to the right are where you would get
your results.

What you're looking to accomplish can definitely be done,
but I think that your worksheet layout is wrong.

If you'd like, send the workbook directly to me:

and I'll take a look at it for you.

John

wrote in message ...
Ok, I'll see if I can explain myself a little better.

What I want to do is create a formula in C7 that takes the
value in B7, looks across from S7:CD7 (where I have the
results and scores for those results) and finds the value
and returns the score.

Now, as an example, B7 is 11.24, I have a result of 11.23
in CB7 and a result of 11.32 in CD7. Since the value in
B7 is between those 2 numbers I want it to return the
score for the lesser result (CB7). The score for CB7 is
located in CA7.

I have the result in one column and the score for that
result in the column immediately to the left of that, so
the formula is looking for the score to the left of that
result. Can this be done?

Thanks for all your replies already!!

-----Original Message-----
Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an individuals goal
and actual result, but I need to have approx. 60 IF
statements in order to do this. Does anyone know of any
way to accomplish this? Any help would be greatly
appreciated! Thanks!
.

Danita wrote:
I need to create a formula that in words says:

If cell a1 = 80 then put 7, if a1 = 120 = then put 10, if a1=160,
then put 13

I can't figure out for 3 options, versus 2
Help me

Hi Danita
try
=IF(A1=80,7,IF(A1=120,10,IF(A1=160,13,"")))

Frank

Try

=VLOOKUP(A1,{80,7;120,10;160,13},2,0)

--

Regards,

Peo Sjoblom


"Danita" wrote in message
...
I need to create a formula that in words says:

If cell a1 = 80 then put 7, if a1 = 120 = then put 10, if a1=160, then put
13

I can't figure out for 3 options, versus 2
Help me

Thanks Frank it worked.