P
phowe43
I have an worksheet that requires extensive manual data entry. Human nature
says people will make keying errors. I'm looking for a safe guard.
If b3 is Starting Mileage / b4 is Ending mileage and b5 is the difference of
the two - how can I place a rule in b5 that basically says "b4" MUST be
greater than "b3".
Can I expand this further so that if b5 is greater than 600 (unlikely that a
driver would drive more than 600 miles in a given day), that it won't allow
entry. Basically forcing the data entry person to take a second look because
more than likely they made a keying error.
says people will make keying errors. I'm looking for a safe guard.
If b3 is Starting Mileage / b4 is Ending mileage and b5 is the difference of
the two - how can I place a rule in b5 that basically says "b4" MUST be
greater than "b3".
Can I expand this further so that if b5 is greater than 600 (unlikely that a
driver would drive more than 600 miles in a given day), that it won't allow
entry. Basically forcing the data entry person to take a second look because
more than likely they made a keying error.