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.