Formulas IF OR ELSE

[Munkholm]

I´m trying to get a formula to return different text strings, depending on the value in another parameter (PARAM_A)

IF(PARAM_A = 1, "Text option A", " ") OR IF(PARAM_A = 2, "Text option B", " ") OR IF(PARAM_A = 3, "Text option C", " ")

I can get it working with just one option:

IF(PARAM_A = 1, "Text option A", " ")

Any, and All help, is greatly apreciated ! Thanks.

[ptranberg]

Hi Klaus
Maybe just use IF. Only use OR if you want two statements to controle the value.
IF(PARAM_A=1,"Text option A",IF(PARAM_A=2,"Text option B",IF(PARAM_A=3,"Text option C"," ")))

Regards
Peter

[Munkholm]

Whoohaaa. Thanks Peter, that works like a charm :-)