Nested IF Formula error
Nested IF Formula error
The following currency formula returns a 'sytax error for given formula' error message. What is wrong with this formula. The Potentials.Package field is a picklist field.
IF(Contains(${Potentials.Package},'A'), 1.00,
IF(Contains(${Potentials.Package},'B'), 2.00,
IF(Contains(${Potentials.Package},'C'), 3.00,
IF(Contains(${Potentials.Package},'D'), 4.00,
IF(Contains(${Potentials.Package},'E'), 5.00,
IF(Contains(${Potentials.Package},'F'), 6.00, 0.00))))))