Thanks Max for your time, really appreciated.
I should have briefly explained what I'm doing, sorry. This database thing
is an assessment tracker for grading students, it has a bucket load of stuff
involved within it's framework...and I might add that I've had a lot of help
from people like yourself andothers from this discussion group. So as you can
see I'm NOT Excel savvy.

Firstly, the other cells you asked about do contain other numbers/letters
etc that are entered in at variuos times.
Secondly, numbers in the discontiguous range are also entered in at
different times during the students course. This particular range reflects a
co-assessment of several subjects. So H8 being where the result of my desired
return should show when the right conditions are entered into the
discontiguous range either HD or C or D or P or F or NGP etc.

Hope all that makes sense Max
Cheers
David

"Max" wrote:

Hazarding a plunge here ..

Assuming the 35 interceding cells within Y8:BR8, ie cells other than the 11
cells specified in your discontiguous range, for eg: Z8, AD8:AK8, AM8:AV8,
etc are just blank cells

Then possibly .. this might yield what you're after, in H8:
=IF(COUNTA(Y8:BR8)=0,"",IF(COUNTIF(Y8:BR8,"R")=11, "R",IF(COUNTIF(Y8:BR8,"=85")=11,"HD",IF(COUNTIF(Y 8:BR8,"=75")=11,"D",IF(COUNTIF(Y8:BR8,"=65")=11, "C",IF(COUNTIF(Y8:BR8,49)=11,"NGP",IF(COUNTIF(Y8:B R8,"<=48")=11,"F","Undefined")))))))

H8 will return "Undefined" if your discontiguous range doesn't satisfy** any
of the 7 conditions specified. I dug these 7 conditions out of your posted
formula <g, and re-arranged it carefully to be evaluated in the correct
sequence, from left to right within the IF construct.

**For example: if all 11 cells in your discontiguous range contain numbers
between 49 to <65, what then is the desired return ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote:
I have this formula that keeps producing a "HD" in the destination cell H8
even though it reads this way...
=IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8 =""),"",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8, BQ8,BR8=49),"NGP",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ 8,BN8,BO8,BQ8,BR8<=48),"F",IF(AND(Y8,AA8,AB8,AC8,A L8,AW8,BJ8,BN8,BO8,BQ8,BR8="R"),"R",IF(AND(Y8,AA8, AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8=85),"HD",IF(A ND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8=75) ,"D",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8 ,BR8=65),"C")))))))

So could someone help me to understand this formula or what I might be doing
wrong.