Skip to Main Content

IFThen Function - Text Result Problem

ankistJul 15 2010 — edited Jul 19 2010
Helllo,

There is a problem as text results of IFThen function seems "Zero" value.

I wrote a IFThen function as below

IfThen([CJ]=1,[CN],IfThen([CJ]=2,[CO],IfThen([CJ]=3,[CP],IfThen([CJ]=4,[CQ],IfThen([CJ]=5,[CR],IfThen([CJ]=6,[CS],IfThen([CJ]=7,[CT],Ifthen([CJ]=8,[CU],IfThen([CJ]=9,[CV],IfThen([CJ]=10,[CW],[CX]))))))))))

and all results are in a cell as text.

but with same rule I run with numeric value, the results are calculated rightly.

How can I run IFThen funciton with text result?

thnks,
Comments