Have form based on word tables...
In cell A1 there is a dropdown, with 1, 2, 3, 4. In Cell A2 I want to display a value for each of the numerals in the dropdown when selected. Example: 1=0.25, 2=0.50, etc.
How can I get Cell A2 to correctly display the numeric value? As a test, I tried using a calculation field in A2 as: =IF(A1=1,0.25,"") but am not getting any value pulled up. I would need possibly a nested IF statement if this is the same as the IF, THEN, ELSE. Various iterations of the formula only elicit error messages like, "Unexpected end of message" or error ,"....Am I not taking the right approach?
My thanks