Syntax Error? Every thing works except one option.
I have created a web form ever thing works fine except one of the look ups, and i cant understand why all the rest work fine.
The form uses a drop down then a calculated filed, again it works fine except for the "26 Feet To 30 Feet=200" part. The calculated field function is:
if([Vehical_type]="Pontoon Boat", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180,26 Feet To 30 Feet=200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD") + 20,if([Vehical_type]="RV", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180, 26 Feet To 30 Feet =200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD"), if([Vehical_type]="Boat", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180, 26 Feet To 30 Feet =200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD"), if([Vehical_type]="5th Wheel", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180, 26 Feet To 30 Feet =200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD"),"TBD"))))
The list form the drop down is:
18 Feet or Under
19 Feet To 25 feet
26 Feet To 30 Feet
31 Feet To 35 Feet
36 Feet To 40 Feet
Over 40 Feet
