Forum Discussion
Need help with excel 2016
This is what I'm trying to do and can not figure it out. thanks for any help
| You want to make it easier for an elementary aged child to practice basic subtraction. The child will enter different numbers in the subtraction equation cells(E43:E44 and G43:G44), then enters their answer to the equations in E45 and G45. You want the child to see immediately if their answers are right or wrong. Create an IF (row 47) that will test whether the answers inserted are correct. Returning "Correct" for the True and "Try again" for the False for the arguments. Once written explore different equations and answers to test your IF. |
1 Reply
Try using a formula like this:
=IF((E43-E44)=E45,"Correct","Try Again!")
You can also throw in some conditional formatting to make the correct answers turn green and the incorrect red. (See attached File)
