text formula help
 

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

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

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

Can anyone help please?:confused:


--
sheen
------------------------------------------------------------------------
sheen's Profile: http://www.excelforum.com/member.php...o&userid=32712
View this thread: http://www.excelforum.com/showthread...hreadid=525454

text formula help
 

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")

--
Greetings from New Zealand
Bill K
"sheen" wrote in
message ...

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

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

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

Can anyone help please?:confused:


--
sheen
------------------------------------------------------------------------
sheen's Profile:
http://www.excelforum.com/member.php...o&userid=32712
View this thread: http://www.excelforum.com/showthread...hreadid=525454

text formula help
 

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



sheen wrote:
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

text formula help
 

=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.
--
Greetings from New Zealand
Bill K
"sheen" wrote in
message ...

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

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

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

Can anyone help please?:confused:


--
sheen
------------------------------------------------------------------------
sheen's Profile:
http://www.excelforum.com/member.php...o&userid=32712
View this thread: http://www.excelforum.com/showthread...hreadid=525454