Hello!
I am building out a simple math sheet for my daughter. Trying to keep her learning during the times of COVID! The format is as follows:
Cell C7: "48" (or some other number)
Cell D7: "+" (or some other mathematical operator that I manually insert such as *, -, /, etc)
Cell E7: "20" (or some other number)
Cell I7: [she inputs her answer here, i.e. "68"]
What I am trying to figure out is a formula which executes the equation shown by C7 D7 E7 ("48 + 20") and compares it to her answer in cell I7. If correct, responds "Correct", if not "Is that your final answer??". So what I have so far is this:
=IF(I7=(C7,D7,E7),"CORRECT","IS THAT YOUR FINAL ANSWER??")
It results in error because (C7,D7,E7) is not the correct way to express the equation. What is the correct way to express it? If D7 were the same every time, this would be easy as I would just fix the mathematical operator between c7 and e7, but making it a reference to a mathematical operator I think is the challenge. Any help would be welcome.
Thanks!
I am building out a simple math sheet for my daughter. Trying to keep her learning during the times of COVID! The format is as follows:
Cell C7: "48" (or some other number)
Cell D7: "+" (or some other mathematical operator that I manually insert such as *, -, /, etc)
Cell E7: "20" (or some other number)
Cell I7: [she inputs her answer here, i.e. "68"]
What I am trying to figure out is a formula which executes the equation shown by C7 D7 E7 ("48 + 20") and compares it to her answer in cell I7. If correct, responds "Correct", if not "Is that your final answer??". So what I have so far is this:
=IF(I7=(C7,D7,E7),"CORRECT","IS THAT YOUR FINAL ANSWER??")
It results in error because (C7,D7,E7) is not the correct way to express the equation. What is the correct way to express it? If D7 were the same every time, this would be easy as I would just fix the mathematical operator between c7 and e7, but making it a reference to a mathematical operator I think is the challenge. Any help would be welcome.
Thanks!