I don't believe I know what you're talking about when you say "my 1,2,3,4."

Don't get me wrong, I know that the code is nothing more than a giant
cluster of information. I just don't know enough about the code on Excel to
be able to code it better.

You see, what I'm trying to get with this is, if your age is 17-26, this is
what your point values count as. If you are 27-39, this is what your scores
count as. If you are 40-45, this is what they count as. And if you are 46+,
that is what they count as.

I have two cells tied into this one.

"Don Guillett" wrote:

Without looking too closely, first I would recommend better organization
such as
if(g845,1,if(g840,2,if(g827,3,4)))
then do the same for your 1,2,3,4

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darryl_Neeley" wrote in message
...
It's a pretty long formula for this one cell, which I am trying to make
work.
Basically, I want it to where if there is nothing in the preceding cell,
for
this cell to display nothing. However, I believe I have one too many
functions in the cell to be able to add the necessary extra IF function.

I'm trying to turn this:

=IF(G8<27,IF(N8<135,"Fail",IF(N8225,"1st",IF(N81 75,"2nd",IF(N8134,"3rd","Fail")))),IF(G8<40,IF(N8 <110,"Fail",IF(N8200,"1st",IF(N8150,"2nd",IF(N8 109,"3rd","Fail")))),IF(G8<46,IF(N8<88,"Fail",IF(N 8175,"1st",IF(N8125,"2nd",IF(N887,"3rd","Fail") ))),IF(G845,IF(N8<65,"Fail",IF(N8149,"1st",IF(N8 99,"2nd",IF(N864,"3rd","Fail"))))))))

into this:

=IF(N8="","",IF(G8<27,IF(N8<135,"Fail",IF(N8225," 1st",IF(N8175,"2nd",IF(N8134,"3rd","Fail")))),IF (G8<40,IF(N8<110,"Fail",IF(N8200,"1st",IF(N8150, "2nd",IF(N8109,"3rd","Fail")))),IF(G8<46,IF(N8<88 ,"Fail",IF(N8175,"1st",IF(N8125,"2nd",IF(N887," 3rd","Fail")))),IF(G845,IF(N8<65,"Fail",IF(N8149 ,"1st",IF(N899,"2nd",IF(N864,"3rd","Fail"))))))) ))

It always highlights the last IF function, which leads me to believe that
it
is the one IF function too many.

Any ways I could get around this, right offhand? I thought of possibly
making a table in another sheet, but I'm trying to avoid that if possible.
Thanks for the help.