If then statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to write a simple program to help my niece with multiplication. I want it to have a simple problem, ie 4 X 5 = ? Then have it ask to input an answer and if the answer = 20, then return Correct, if the answer is not correct then return wrong. I know I need to nest if then statements but it isn't working for me?
 
Hi jrb53

A1 and B1 for inputs of the figures
C1 for the answer
D1:
=IF(C1=A1*B1,"Correct","Wrong")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
jrb53 said:
I am attempting to write a simple program to help my niece with
Click to expand...
multiplication. I want it to have a simple problem, ie 4 X 5 = ?
Then have it ask to input an answer and if the answer = 20, then
return Correct, if the answer is not correct then return wrong. I
know I need to nest if then statements but it isn't working for me?
 
Back
Top