is it posible to apply multiple and or functions in a singl cell?

[Yogesh]

i m making a marksheet using functions.in that marksheet i want to use
"distinctinction" as a column in which i want to show those subjects in which
a students have scored more then 75 marks and i want to use if, and, or
function in such a way as to enable me to get all subject in a single cell in
which student have scored more then 75 marks.
i.e. if i use any if these functions(if,and,or) then i will get any of two
answer which wold be selected by me.like in this statment:
=IF(D9>=40,"Pass","Fail")
in this position i will get either fail or Pass as result..
but i want to get such three results in a single cell...

plz help me!!

 

[Dave]

Hi,
I think you just need a nested IF formula.
Try:
=IF(D9>=75,"Distinction",IF(D9>=40,"Pass","Fail"))
Regards - Dave.

 

[Reitanos]

It sounds like you want multiple results in a single cell. If so, you
can concatenate multiple functions by using &:

=IF(D9>=40,"Pass A","Fail A")&IF(D10>=40,"Pass B","Fail
B")&IF(D11>=40,"Pass C","Fail C")

Is that what you are looking for? I'm not sure where the 75 comes into
play, but you could put all of the above inside an IF too:
=IF(SUM(D911)>=75,IF(D9>=40,"Pass A, ","Fail A, ")&IF(D10>=40,"Pass
B, ","Fail B, ")&IF(D11>=40,"Pass C","Fail C"),"")