I need a tip and a formula. after many attempts, I now turn to you. I hope for help.
1) Needed tip:
For a textbox (value1) with only numbers, how can I use the OK key to pass the entered value to the result textbox (erg1) when entering via the number field that is displayed?
2) formula help needed:
- there are 4 result fields with the names: erg1, erg2, erg3, erg4
Conditions for the formula:
the formula must be active only if the value (example erg2) is in the range ...
- between 100 and 295
or - between 400 and 695
or - between 800 and 945.
If a result overtakes another single result or several of the other results in these ranges, then the value 50 is subtracted from the respective overtaken results and added to the result field of the overtaker.
Can anyone give me a hint?
I despair for 6 days on it.
Thanks a lot
Andy