Notices
 

Thread: I need some help with Excel please.

Results 1 to 2 of 2
  1. I need some help with Excel please. 
    #1
    Active Member
    Join Date
    May 2007
    Posts
    264
    I am trying to do a quiz where you have to guess something from a picture and put your answer in a box.
    If you are right or wrong the box underneath will tell you if you are correct or not.

    Can anyone help me with the formulae I need to be able to add the answer, connect to the right/wrong box but without anyone seeing the answers please?

    To give you some idea, here is a link to one similar game.

    http://uk.download.yahoo.com/ne/fu/a...impguestl1.xls

    I would appreciate any help you can give, as I really dont know excel very well at all.

    Mandy
    x
     
     

  2. Re: I need some help with Excel please. 
    #2
    Newbie
    Join Date
    Dec 2006
    Posts
    40
    You need an 'if' statement which displays different answers depending on what you set the condiions to be.

    If you wanted an answer of 'Buzz Aldrin' in B2 then you would need to input =IF(B2="Buzz Aldrin";"correct";"wrong&quot The bit in black is where the rule goes (just replace the cell and the answer), the red is the answer if the cell is filled with 'Buzz Aldrin' and the other colour which i cannot remember is the part where you put the answer if they have got it wrong.

    You might need commas instead of the semi-colons, im not sure as i'm using open-office not microsoft excel

    Hope this helps and i hope its right.
     
     

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •