A
A Hopper
On a form I would like to create a way of doing the
following calculation.
When the Total Number is entered in a text I want to
calculate the highest number in a Range of numbers that
would give an even number answer. I would like the answers
in two text box (Highest Number, Quantity)
Example : Total Number = 17500 Range = greater than 1
and equal to or less than 9.
Answers are 7 (in Highest Number text box) and 2500 (in
Quantity text box).
2, 4, and 5 in this range, also give even number
answers but 7 is the highest number in the range that
gives an even number.
The Total Number entered and the Range can be changed.
Thanks for your help
Allan
following calculation.
When the Total Number is entered in a text I want to
calculate the highest number in a Range of numbers that
would give an even number answer. I would like the answers
in two text box (Highest Number, Quantity)
Example : Total Number = 17500 Range = greater than 1
and equal to or less than 9.
Answers are 7 (in Highest Number text box) and 2500 (in
Quantity text box).
2, 4, and 5 in this range, also give even number
answers but 7 is the highest number in the range that
gives an even number.
The Total Number entered and the Range can be changed.
Thanks for your help
Allan