Check if A1 equals the sum of A2+A3 display "correct" if not "Try again"
Two part question:
Q1:
if number in E57 plus number in E58 equals number in E59 than display "Complete"
if number in E57 plus number in E58 do NOT equal number in E59 than display "Try Again"
Q2:
if sum of numbers in E2:E55 PLUS Sum of numbers F2:F55 is Equal to E59 than display "Complete"
if sum of numbers in E2:E55 PLUS Sum of numbers F2:F55 is NOT Equal to E59 than display "Try again"
Thanks!
haven't used excel in years
-EM
homework, I wonder?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I am making test of sorts for my students in chem.Originally Posted by TMS
I am trying also challenging myself with excel forms whenever possible, but this has me stumped.
-teacher
Last edited by eatmydust; 07-23-2014 at 06:44 AM. Reason: clarify
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
or maybe even:
Formula:Please Login or Register to view this content.
Regards, TMS
You may also need to consider how many significant figures you expect your students to find in the answer. As written, Excel may expect your students to find all 15 digits that Excel's double precision calculates (that's what "exactly equal" means to Excel). If appropriate, you may want to test for abs(sum(values)-E59)<epsilon where epsilon is some "tolerance" value that represents how closely you expect your students to find the correct answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks