Regulator Posted October 16, 2005 Report Share Posted October 16, 2005 Ok, I've been given this task at uni where I have a spreadsheet which has a list of kids names and their marks in 2 tests. In one of the columns, I need Excel to automatically specify if the student passed or not. The pass mark is 50% and anything below this is a fail. Can someone please help me out as I have been trying this since last night and i am getting nowhere. I am unsure of why we've been told to do this as I am doing an Economics, Finance and Banking course at Portsmouth Uni ... For anyone who wants to work, its a good idea to come here as I haven't seen any fit gals ... O well, I'm just hoping i'll see a tyresmoker's car, that should keep me company admiring it ... hehe. O, just a note, I spotted an Octavia VRS this morning. If its still there when I go home then i'll take a pic with my phone and stick it up on Spotted. Any help with this problem would be most appreciated (and by this i mean the gals and the excel prob) Link to comment Share on other sites More sharing options...
Regulator Posted October 16, 2005 Author Report Share Posted October 16, 2005 o, the book tells me i need to use the IF function. Link to comment Share on other sites More sharing options...
bazza_g Posted October 16, 2005 Report Share Posted October 16, 2005 afraid I know pretty much feck all about Excel - I'm sure another TSN'er will be along soon to assist Link to comment Share on other sites More sharing options...
Regulator Posted October 16, 2005 Author Report Share Posted October 16, 2005 I've found it!! http://spreadsheets.about.com/cs/excelfunction1/a/iffunction.htm quite a clever function actually. Link to comment Share on other sites More sharing options...
GCab Posted October 16, 2005 Report Share Posted October 16, 2005 I'd have thought the relevance to what you're studying is pretty obvious Just because the example is about education doesn't mean you won't need to do something similar, surely. Anyway, from the look of the page you found, your tutors have obviously seen the same page and nicked the example pretty much word for word - handy for you Link to comment Share on other sites More sharing options...
dazdot Posted October 16, 2005 Report Share Posted October 16, 2005 While we are on the subject of spreadsheets, could some one tell me, if there is a way of finding out if a certain cell is used (linked to/from?) in any of the calculations on the spreadsheet? Link to comment Share on other sites More sharing options...
scooby_simon Posted October 16, 2005 Report Share Posted October 16, 2005 [ QUOTE ] While we are on the subject of spreadsheets, could some one tell me, if there is a way of finding out if a certain cell is used (linked to/from?) in any of the calculations on the spreadsheet? [/ QUOTE ] I think there is (link to or link from (maybe) The help on excel is actually fairly good so try it. 2 minutes seconds found the "is" function which may do most of what you want. : [ QUOTE ] IS Functions See Also This section describes the nine worksheet functions used for testing the type of a value or reference. Each of these functions, referred to collectively as the IS functions, checks the type of value and returns TRUE or FALSE depending on the outcome. For example, the ISBLANK function returns the logical value TRUE if value is a reference to an empty cell; otherwise it returns FALSE. Syntax ISBLANK(value) ISERR(value) ISERROR(value) ISLOGICAL(value) ISNA(value) ISNONTEXT(value) ISNUMBER(value) ISREF(value) ISTEXT(value) Value is the value you want tested. Value can be a blank (empty cell), error, logical, text, number, or reference value, or a name referring to any of these, that you want to test. Function Returns TRUE if ISBLANK Value refers to an empty cell. ISERR Value refers to any error value except #N/A. ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). ISLOGICAL Value refers to a logical value. ISNA Value refers to the #N/A (value not available) error value. ISNONTEXT Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.) ISNUMBER Value refers to a number. ISREF Value refers to a reference. ISTEXT Value refers to text. Remarks The value arguments of the IS functions are not converted. For example, in most other functions where a number is required, the text value "19" is converted to the number 19. However, in the formula ISNUMBER("19"), "19" is not converted from a text value, and the ISNUMBER function returns FALSE. The IS functions are useful in formulas for testing the outcome of a calculation. When combined with the IF function, they provide a method for locating errors in formulas (see the following examples). Example 1 The example may be easier to understand if you copy it to a blank worksheet. How? Create a blank workbook or worksheet. Select the example in the Help topic. Do not select the row or column headers. Selecting an example from Help Press CTRL+C. In the worksheet, select cell A1, and press CTRL+V. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode. 1 2 3 4 A B Formula Description (Result) =ISLOGICAL(TRUE) Checks whether TRUE is a logical value (TRUE) =ISLOGICAL("TRUE") Checks whether "TRUE" is a logical value (FALSE) =ISNUMBER(4) Checks whether 4 is a number (TRUE) Example 2 The example may be easier to understand if you copy it to a blank worksheet. How? Create a blank workbook or worksheet. Select the example in the Help topic. Do not select the row or column headers. Selecting an example from Help Press CTRL+C. In the worksheet, select cell A1, and press CTRL+V. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode. 1 2 3 4 5 6 A Data Gold Region1 #REF! 330.92 #N/A Formula Description (Result) =ISBLANK(A2) Checks whether cell C2 is blank (FALSE) =ISERROR(A4) Checks whether #REF! is an error (TRUE) =ISNA(A4) Checks whether #REF! is the #N/A error (FALSE) =ISNA(A6) Checks whether #N/A is the #N/A error (TRUE) =ISERR(A6) Checks whether #N/A is an error (FALSE) =ISNUMBER(A5) Checks whether 330.92 is a number (TRUE) =ISTEXT(A3) Checks whether Region1 is text (TRUE) [/ QUOTE ] Link to comment Share on other sites More sharing options...
Thorburn Posted October 16, 2005 Report Share Posted October 16, 2005 [ QUOTE ] I am doing an Economics, Finance and Banking course at Portsmouth Uni ... [/ QUOTE ] Good to see another Pompy student on here, reckon you can make it to some of the meets in the future? I'm doing Computer Science, currently in Swindon on my sandwich year though. Link to comment Share on other sites More sharing options...
Gaunty Posted October 16, 2005 Report Share Posted October 16, 2005 <font class="small">Code:</font><hr /><pre> A B C 1 Student1 30% =if(B1>=0.5,"Pass","Fail") 2 Student2 60% =if(B2>=0.5,"Pass","Fail") </pre><hr /> <smug>What's hard about that?</smug> Link to comment Share on other sites More sharing options...
Mollox Posted October 16, 2005 Report Share Posted October 16, 2005 <font color="gray"><agreement></font>Yeah! <font color="gray"></agreement></font> Link to comment Share on other sites More sharing options...
Regulator Posted October 18, 2005 Author Report Share Posted October 18, 2005 [ QUOTE ] I'd have thought the relevance to what you're studying is pretty obvious Just because the example is about education doesn't mean you won't need to do something similar, surely. Anyway, from the look of the page you found, your tutors have obviously seen the same page and nicked the example pretty much word for word - handy for you [/ QUOTE ] I must be stoopid because the only relevance I see is me having to do tests. IT doesn't play a massive part in Economics! Link to comment Share on other sites More sharing options...
Mollox Posted October 18, 2005 Report Share Posted October 18, 2005 [ QUOTE ] IT doesn't play a massive part in Economics! [/ QUOTE ] I think you have a lot to learn yet!! Link to comment Share on other sites More sharing options...
NewNiceMrMe Posted October 18, 2005 Report Share Posted October 18, 2005 [ QUOTE ] IT doesn't play a massive part in Economics! [/ QUOTE ] Ermmmm, wow. Link to comment Share on other sites More sharing options...
Regulator Posted October 18, 2005 Author Report Share Posted October 18, 2005 I think the task was to learn how to use the computers at uni and to get familiar with using a network. Anyhow, my next major task is to write a webpage all using notepad and it has to be done in HTML. When I was doing my GCSE's I cheated and did all of my webpages in Publisher, well not cheated, just avoided the HTMl option. I know that in frontpage you can navigate things in there similar to word and then click on the tab and it will convert everything into HTML. However, if it turns up with some long complicated code then I think that this will seem too obvious that I have cheated. The next task is to produce a webpage which is to do with people inputting their data for a cv/recruitment company ... Anyone feel like writing me one?? Link to comment Share on other sites More sharing options...
Mollox Posted October 18, 2005 Report Share Posted October 18, 2005 I'm getting the feeling that its in your best interests NOT to cheat! It couldn't me more obvious if you used a html editor I would say. Just keep it simple and concentrate on simplicity (read the functionality of your form). There are 1,001 web sites dedicated to explaining html tags. You can either do one scrolling page that simply works top to bottom in one dimension or you can get stuck into tables to order your data. These can be quite confusing to hand write and I wouldn't recommend anything more than basic tables at the moment. Now do it yourself! Link to comment Share on other sites More sharing options...
Mollox Posted October 18, 2005 Report Share Posted October 18, 2005 Understanding HOW websites work and the basic challenges involved in their creation and maintenance I would say will be a great advantage to you if you intend to move along in the world We're still divided into the "knows" and "haven't a clues" and I know which lot the world is moving against! Link to comment Share on other sites More sharing options...
Regulator Posted October 18, 2005 Author Report Share Posted October 18, 2005 ok ... I think i'll keep it simple, that way they can't say I cheated and just passing that unit is better than gettin a fail for it. ... But if any1 does wana create me a simple webpage, feel free 2 do so!!! Link to comment Share on other sites More sharing options...
Mollox Posted October 18, 2005 Report Share Posted October 18, 2005 Do it and I'll delete it! Let him learn!! Link to comment Share on other sites More sharing options...
Regulator Posted October 18, 2005 Author Report Share Posted October 18, 2005 [ QUOTE ] Do it and I'll delete it! Let him learn!! [/ QUOTE ] LOL! hehe Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now