asked on May 22, 2017
•
Show version history
I have a client who has a formula from radio buttons and then assigned this value.
He is adding values from field 1 and field 2 into a variable called Assessment_Total_Value.
Ex).
- Field 1 = 1
- Field 2 = 4
- Assessment_Total_Value = 5
He wants the next field to use Assessment_Total_Value to do calculations. The formula he is using is...
=PRODUCT(Assessment_Total_Value, 100)
but instead of the variable being multiplied by a 100.. he gets 100 (should be getting 500).
Any ideas on what it may be? A syntax mistake?
0
0