| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is it posible to apply multiple and or functions in a singl cell?
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is it posible to apply multiple and or functions in a singl cell?
Hi,
I think you just need a nested IF formula. Try: =IF(D9=75,"Distinction",IF(D9=40,"Pass","Fail")) Regards - Dave. "Yogesh" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is it posible to apply multiple and or functions in a singl cell?
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(D9:D11)=75,IF(D9=40,"Pass A, ","Fail A, ")&IF(D10=40,"Pass B, ","Fail B, ")&IF(D11=40,"Pass C","Fail C"),"") On Apr 23, 5:40 pm, Yogesh wrote: 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to apply absolute cell referencing to multiple cells at once? | Excel Worksheet Functions | |||
| apply arithmetic functions on special multiple cells | Excel Worksheet Functions | |||
| Can I apply a "score" based on multiple cell values? | Excel Worksheet Functions | |||
| apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
| How do I automatically alphabetize multiple worksheets in a singl. | Excel Discussion (Misc queries) | |||
Linear Mode
