How do I filter a text field based off of the calculated value in another text field?

Stephen Beringer — Tue, 01 Apr 2014 21:47:19 GMT

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!!

Newbie Questions

How do I filter a text field based off of the calculated value in another text field?