| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I string formulas together in Excel to display variables
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 variables
Something like
Create a table like so In M1:Nn 0 Normal 75 Distinction 101 High Distinction 110 Credit and use =VLOOKUP(A1,M1:N 10,2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DavidB" wrote in message ... 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 variables
WHat error messages
or give us an example of the edited formula that doesn't work Steve On Wed, 04 Oct 2006 12:28:01 +0100, 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
Thanks Steve 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 B13 then I want cell W13 to output either HD, D, C, NGP. Does that make sense?? My direct email address is Cheers David "SteveW" wrote: WHat error messages or give us an example of the edited formula that doesn't work Steve On Wed, 04 Oct 2006 12:28:01 +0100, 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
=LOOKUP(B1,{0,49.65,75,84},{"NGP","C","D","HD"})
Gord Dibben MS Excel MVP On Wed, 4 Oct 2006 15:42:02 -0700, DavidB wrote: Thanks Steve 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 B13 then I want cell W13 to output either HD, D, C, NGP. Does that make sense?? My direct email address is Cheers David "SteveW" wrote: WHat error messages or give us an example of the edited formula that doesn't work Steve On Wed, 04 Oct 2006 12:28:01 +0100, 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 variables
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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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 |
|
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I string formulas together in Excel to display variable
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
