ravik:I want to write a conditional formula where I want a value 1 assigned to a variable x if the symbol is IBM, 2 if the symbol is MSFT, 3 if the symbol us PRTY etc.
I guess that would be something like :
If( C=Security("C:\MS\Data\IBM",C), value1, if(C=Security("C:\MS\Data\MSFT",C), Value2, if(C=Security("C:\MS\Data\PRTY",C), value3,0)))
How did you do it ? :)