Ask Experts Questions for FREE Help !
Ask
    vbg1980's Avatar
    vbg1980 Posts: 10, Reputation: 1
    New Member
    		  
    #1

    Aug 12, 2007, 11:47 AM
    Excel programming
    Hi,

    I would like to know whether anyone knows how to do the following, in excel.

    Say that I am grading somebody, and my grading options are from 1 to 4. I want to create a condition in a cell, that when someone is uncertain about the score that they want to give, and they assign 2 or 3, then the cell would automatically read the highest value, that is 3.

    Thanking you!
    jstrike's Avatar
    jstrike Posts: 418, Reputation: 44
    Full Member
    		  
    #2

    Aug 14, 2007, 02:12 PM
    Quote Originally Posted by vbg1980
    Hi,

    I would like to know whether anyone knows how to do the following, in excel.

    Say that I am grading somebody, and my grading options are from 1 to 4. I want to create a condition in a cell, that when someone is uncertain about the score that they want to give, and they assign 2 or 3, then the cell would automatically read the highest value, that is 3.

    Thanking you!!
    You could do this with an if statement but that would get kind of long.

    Take a look at the vlookup function. If you create a small table somewhere on your spreadsheet with the possible entry values and the value you want assigned you can lookup what they enter and get the value that should be assigned.

    Hope that makes sense.
    vbg1980's Avatar
    vbg1980 Posts: 10, Reputation: 1
    New Member
    		  
    #3

    Aug 23, 2007, 12:04 PM
    I have tried that today, not sure I'm getting it.

    I will persist tomorrow, and tell you how that goes. Thanks for your answer :)
    jstrike's Avatar
    jstrike Posts: 418, Reputation: 44
    Full Member
    		  
    #4

    Aug 23, 2007, 12:47 PM
    Post the spreadsheet on here and I'll take a look at it when I have a minute.
    vbg1980's Avatar
    vbg1980 Posts: 10, Reputation: 1
    New Member
    		  
    #5

    Aug 30, 2007, 11:47 AM
    Thanks for your help :) I managed to figure it out - I used IF function after all and it wasn't that complicated because it was an either or answer I wanted.

    Thanks!
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

C programming [ 2 Answers ]

I'll be extremely thankful if u could provide me with a c program that convert a given nfa to dfa

C programming [ 2 Answers ]

I need some help from you regarding a particular problem. I am using libnet raw packet library (libnet_build_ethernet) for transferring data over the network. For this, I have to first convert all the data to u_char type and then serialize them to contiguous memory locations. Can...

Qt programming [ 1 Answers ]

Hi, My name is anshahmed.I am doing final year B.TECH.Now I am doing a project and I want to use qt programming .Whie I was compiling the qt programm the compiler giving errors in header file(qpplicaton.h) .how can I compile the qt programm.

C programming help [ 1 Answers ]

Hi people I want to shut down my system after a specified time I want to use the time() method but I need to know the exe file that runs after the specified time. Please let me know also if there is any other way to shut down my system after some particular time Thank you Best regards

View more questions Search