Ways to calculate Pass/Fail result based on range of numbers -
11-27-2003
, 08:50 PM
I have a form I am working on. On that form I have fields which perform
calculations. What is the easiest way to define a pass or fail result based
on those numbers from the calculations being compared to a range of numbers.
For example the number 45 being compared to a range of 25-60 and since it
falls within concludes with a Pass result. The thing is there will be 20 or
so conclusions each one has its own range for comparison and a pass result
is contingent to all falling within there assigned ranges. So any
individual result/calculation out of range would come up Fail. ? I know
it is probably elementary... lol but me still Noob.. but trying
Any help appreciated
MTHarris |