| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I string formulas together in Excel to display variable
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
| "Microsoft Excel can't display Clip Art" | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel Error when copying formulas | Excel Worksheet Functions | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Hybrid Mode
