Hi there Roger...how are things in the UK (I think thats where you are)
Many, Many thanks for the amendment...The only nesting I'm familiar with is
the one that birds do. I think it will take quite a while to get my head
around Excel...but I'm not giving up, I've promised myself to finish this
assignment even though I have till Christmas.

Cheers
David

"Roger Govier" wrote:

Hi Dave

You are exceeding Excel's limit of 7 levels of nesting, and you don't
have a final FALSE result if all other tests fail.
I often find it easier to see the problem if I insert line feeds after
each If statement

=IF(AZ13="",""
IF(BK13="","",
IF(BX13="","",
IF(AZ13="CA","CA",
IF(BK13="CA","CA",
IF(BX13="CA","CA",
IF(AZ13="CNA","CNA",
IF(BK13="CNA","CNA",
IF(BX13="CNA","CNA"
)))))))))

Try amending to

=IF(OR(AZ13="",BK13=""),"",
IF(AZ13="CA","CA",
IF(AZ13="CNA","CNA",
IF(OR(BK13="CA",BX13="CA"),"CA",
IF(OR(BK13="CNA",BX13="CNA"),"CNA",
""
)))))


--
Regards

Roger Govier


"DavidB" wrote in message
...
Hi All

Can anyone tell me why this formula isn't working please:
=IF(AZ13="","",IF(BK13="","",IF(BX13="","",IF(AZ13 ="CA","CA",IF(BK13="CA","CA",IF(BX13="CA","CA",IF( AZ13="CNA","CNA",IF(BK13="CNA","CNA",IF(BX13="CNA" ,"CNA")))))))))

Cheers
David

"Roger Govier" wrote:

You're very welcome David. Thank you for the feedback.

--
Regards

Roger Govier


"DavidB" wrote in message
...
Once again thank you everyone. Especially you Roger...It works!!!
You
guys
have made this project much easier and I don't feel nearly as bad
now
taking
on this assignment.
I do have part 2 to all this but will give my brain a rest for a
day
or two
then if I may, get back to you and ask some more mind numbing
questions....

Many Thanks
David

"Roger Govier" wrote:

Hi David

Sorry I hadn't tested, just amended your formula.
Excel regards Text as being higher than numbers, so you need to
move
that test to the beginning.
I also moved the test for empty cells to the beginning.
Tested this time, and appears to give all the correct results.

=IF(B14="","",
IF(B14="N","NGP",
IF(B14=85,"High Distinction",
IF(B14=75,"Distinction",
IF(B14=65,"Credit",
IF(B14=50,"Pass","Fail"))))))

--
Regards

Roger Govier


"DavidB" wrote in message
...
Roger, thanks but I even cut and pasted your formula into the
relevant
cell
but it still doesn't work. What I get now when I enter an N into
B14,
is High
Distinction. I must be doing something wrong??? This is what I
now
have in
the formula bar:
=IF(B14=85,"High
Distinction",IF(B14=75,"Distinction",IF(B14=65," Credit",IF(B14=50,"Pass",IF(B14<=49,"Fail",IF(B14 ="N","NGP",""))))))

Cheers
David

"Roger Govier" wrote:

Hi David

Since N is text, you need to wrap it in Quotes.
Also you need the final "" after "NGP" for the case where b14
does
not
meet any of the criteria


=IF(B14=85,"High Distinction",
IF(B14=75,"Distinction",
IF(B14=65,"Credit",
IF(B14=50,"Pass",
IF(B14<=49,"Fail",I
F(B14="N","NGP",""))))))


--
Regards

Roger Govier


"DavidB" wrote in message
...
Thanks everyone for the help. The formula that you have given
me
works
like a
charm, except the last part which I added and once again I've
made
a
mess. So
here is what I need the formuls to do:
=IF(B14=85,"High
Distinction",IF(B14=75,"Distinction",IF(B14=65," Credit",IF(B14=50,"Pass",IF(B14<=49,"Fail",IF(B14 =N,"NGP",))))))
This last part doesn't doesn't produce an NGP when I enter N.

Cheers
David

"Rookie 1st class" wrote:

Roger had it right. Paste this in a5
=IF(A1=85,"High
Distinction",IF(A1=75,"Distinction",IF(A1=65,"Cr edit",IF(A1=50,"Pass",IF(A1<50,"NGP")))))'all
on one line in A5.
=IF(B1=85,"High
Distinction",IF(B1=75,"Distinction",IF(B1=65,"Cr edit",IF(B1=50,"Pass",IF(B1<"","NGP","")))))'
again all one line
Slight modification that doesn't put NGP in empty cell. use
fill
right and
left to correct the formula for all columns.
Lou

"Roger Govier" wrote:

Hi David

Try
=IF(A184,"HD,IF(A174,"D",IF(A164,"C",IF(A149," P","NGP"))))

--
Regards

Roger Govier


"DavidB" wrote in
message
...
Thanks Stefi for your reply, I know that I didn't make
myself
clear so
may I
try to explain in words (hope this works).
What I am trying to do is set up a scoring system for
students.
The
scoring
system is: 85-100 =High Distinction, 75-84 =Distinction,
65-74
=
Credit,
50-64 =Pass, N =NGP. So, for example If I type in
whatever
score
into
cell A1
then I want cell A5 to output either HD, D, C, NGP. Does
that
make
sense??
My direct email address is "
Cheers
David

"Stefi" wrote:

You defined that you want to display "High Distinction"
when
B1384
and
B13<101 but didn't specify the conditions of
Distinction,
Credit,
NGP, Fail...
We need these details to compose the appropriate
formula!

Regards,
Stefi


"DavidB" wrote:

I want to display a range of quotes in one cell from
a
formula
in
that
cell...if you can make sense of that. The first part
of
the
formula
works
well and displays one of five messages but I cant add
any
more
formulas to
the existing one without getting error messages, for
example:
=IF(AND(B1384,B13<101),"High Distinction"). This
works
well
but I
need to
add more to it in order to display Distiction,
Credit,
NGP,
Fail...I am more
than willing to send to anyone who can help me, the
Excel
spreadsheet to have
a look at.
Cheers
David