Using text in Excel

[masona]

I am trying to make a Dolch word exercise for low ability young adult students.
A simple word is mixed up in column A. They have to unscramble it and type correct spelling in column B which will come up with a Well done or Whoops in Column C. I have formatted all columns for text. Formula has worked in first row but not in subsequent ones. Can't see why - any ideas.
<TABLE style="WIDTH: 228pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=303 x:str><COLGROUP><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 6070" width=166><TBODY><TR style="HEIGHT: 28.5pt" height=38><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: #ff6600; WIDTH: 55pt; HEIGHT: 28.5pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65 height=38 width=73>eth</TD><TD style="BORDER-BOTTOM: #ebe9ed 0.5pt; BORDER-LEFT: #ebe9ed 0.5pt; BACKGROUND-COLOR: #ff6600; WIDTH: 48pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed 0.5pt" class=xl66 width=64>the</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff6600; WIDTH: 125pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl68 width=166 x:fmla='=IF(B1="the","Well Done", "Whoops")'>Well Done</TD></TR><TR style="HEIGHT: 28.5pt" height=38><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: #ff6600; HEIGHT: 28.5pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65 height=38>ot</TD><TD style="BORDER-BOTTOM: #ebe9ed 0.5pt; BORDER-LEFT: #ebe9ed 0.5pt; BACKGROUND-COLOR: #ff6600; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed 0.5pt" class=xl67>to</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff6600; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl68>=IF(B5="to","Well Done","Whoops")</TD></TR></TBODY></TABLE>

 

[Oaktree]

Welcome to the board.

I assume that, when you say the formula doesn't work in the subsequent rows, the "doesn't work" part is that it's showing the formula and not the result...

If that's the case, try formatting the cell with the formula as anything other than text (and, afterward, pressing F2 and enter to reconfirm the formula).

 

[masona]

You're brilliant - thanks - that has sorted the problem. I make loads of teaching resources, for young adults with learning disabilities, using Excel for maths but have only just started using it for english. In Excel you can format everything in a larger font size and colour which is more interesting. I have also used drop down menus in Word a lot but you can't make them large font or in colour - or I havent found a way - maybe you know different.
Thanks anyway.