text formula help

S

sheen

I need a formula that will hide the aswer to a picture, unless th
correct answer is typed in the cell.

For example, if the answer to cell B5 is Bread, and Bread is typed int
that cell, I need Bread to appear in B5 and the word Correct in cel
B4.

I've tried using the IF function and keep getting a NAME error.

Can anyone help please?:confused
 
B

Bill Kuunders

You would need to have a cell with the correct answer. Say that would be B6
In B4 enter =if(B5=B6,"correct","try again")
 
P

pau1a

Hi

One way is to use conditional formatting.

Select cell B5, then format, conditional formatting - you can change the font
from there and one idea would be to have the font be white if they didn't
type in "bread", although a less problematic solution may be to select
crossed through so the person can see what they typed.

The formula for B6 would be =IF(LOWER(E10)="bread","correct"," ")
the lower bit is to ensure that the result is not case sensitive, i.e. Bread
and bread would both return correct.

Hope this helps
 
B

Bill Kuunders

=IF(B5="Bread","correct","try again")

you could have a hidden row somewhere with all the correct answers
and change the formula in B4 to =IF(B5=B25,"correct","try again")
and extend the formula accross.
 
Top