IFThen Function - Text Result Problem
ankistJul 15 2010 — edited Jul 19 2010Helllo,
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,