I have been going crazy for a week trying to figure this out (I want to use text boxes NOT cascading drop down).
Text Field 1: User enters Forecast ($$)
Text Field 2: User enters Results ($$)
Text Field 3 (read only): Value = Results / Forecast * 100
Text Field 4 (read only): If Text Field 3 = XX, then compare answer in Text Field 3 to a sharepoint list/column and return YY (lookup/compare function)
So, for example:
Text Field 1: User enters 100
Text Field 2: User enters 86
Text Field 3 (read only): = 86%
Text Field 4 (read only): = 0.48
|
80% |
81% |
82% |
83% |
84% |
85% |
86% |
87% |
88% |
89% |
90% |
|
0.25 |
0.29 |
0.33 |
0.36 |
0.40 |
0.44 |
0.48 |
0.51 |
0.55 |
0.59 |
0.63 |
Any help would be great!!