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!!