Hi
I am trying without much success to find the correct formula expression to resolve the following:-
IF <Value from Picklist field> = 5 then return 35 as value
IF <Value from Picklist field> = 10 then return 43 as value
IF <Value from Picklist field> = 17 then return 46 as value
I then need to be able to use the returned value in another formula field which can have a further expression to resolve
IF<Value from Picklist field> = Yes then multiply the value from above result by 2
Your thoughts on this much appreciated.
Regards
Steve