IF Statements

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

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, 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.
 
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
 
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!!
 
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:
(e-mail address removed)
and I'll take a look at it for you.

John
 
Back
Top