Excel Whizz Kids - Help Needed

[Zdu]

Does anybody know the excel formula for the following:

I want to be able to make a cell say "Correct or Wrong" after typing in some preselected data. EG. like a spelling test. I've tried very things and nothing seems to work.

Free green blob to successful applicants.

[beanie]

you'd need to write a function to return the answer for the given input

if you want to post or PM exactly what you want or roughly what you want I'll lob something together for you

for the love of the green :P

[Colin Marriott]

What .... like if you type into cell B1 the following

=IF(A1=1,"Correct","Wrong")

And then put 0 or 1 in A1

Or am I missing something?

ColinM

[D.D.J]

hi, hope this helps
you could either use "if" statements or you could use conditional formatting so taht if the cell was correct it could turn a preset colour of your choice or if it was wrong then it could also be set a preset colour.....so that it is brought to your attention...if you like you could send a copy of what you d like doing and the document and i could give it a go...just an idea, and i m not saying i d be successful but i d definetly try.

[Zdu]

OK, what I'm trying to is create an excel German translation test for my niece. Duel purpose of spelling and IT introduction.

So, say in cloumn A I have a list of German words. In column B I want her to type the English translation and be told if that's right or wrong. I'm assuming I'll need a hidden column with the English answers.

[Hoppy]

Originally Posted by Zdu

OK, what I'm trying to is create an excel German translation test for my niece. Duel purpose of spelling and IT introduction.

So, say in cloumn A I have a list of German words. In column B I want her to type the English translation and be told if that's right or wrong. I'm assuming I'll need a hidden column with the English answers.

do it like colin said

so it would go cell A1 Morgen cell b1 (she types the answer) cell C1 would be =IF(B1=Morning,"Correct","Wrong")

Hows that ?

[D.D.J]

hi
yep, you ll need a hidden column which you could have on a different page....these are called lookups...so you would do a lookup formula, you can do these either by horizontal or vertical...it depends how u lay the table out....most likely vertical.
ie
=hlookup(e2,a3:b4,2,false)
so e2 would be the german word
a3:b4 would be the range..lookup table that you have highlighted to check it against,
2 because 2 columns/rows
false not really sure on that one but it works with that in the formula. hope this helps

[Zdu]

Waaaaheeeey... sorted.

Get yr heads down as an incoming artillery barrage of blobs is heading all your way...

[KimH]

How about using conditional formatting, this gives you up to 3 nested options for each result cell and for this exercise you would need to use two adjacent ones.

Type "correct" in the first one and "incorrect" in the second and format them both so the font is white i.e. they are invisible under normal view. Then set the conditional format for each result cell so that they refer to the input cell and if the condition is met it changes the font colour to become visible. You can use different colours for the displayed text if you want to.

If you were using it for a spelling test then you could set it up so that the answer text would only become visible if the input was correct (the two cells agree) and it actually displays the word itself next to the input but maybe in a colour.

Hope this makes sense and helps by all means PM me.

[Bob Cooper]

Originally Posted by Zdu

So, say in cloumn A I have a list of German words. In column B I want her to type the English translation and be told if that's right or wrong. I'm assuming I'll need a hidden column with the English answers.

If you use this formula.......

=IF(A1=B1,"correct","wrong")

Then if the word typed in cell B1 matches the word in cell A1 (which could be hidden) then the word "correct" appears in the formula cell. If not, the word "wrong" appears.

Does that help?

Bob