raj74 wrote on Mon, 22 Jun 2009 10:38:01 -0700:

I am trying to write a simple logical condition,
If A = 0, Sigma =1, other wise Sigma =2,

I write it using if function, but I cannot write the small
sigma symbol which is very annoying as the output is
considered. Tried with CHAR(number) but don't have any ascii
value for greek letters. Please help.


Insert Symbol should do the job in Excel if you switch to the Unicode
set of characters.

Lower case sigma is Unicode 03c3 by the way..If your Excel is as
antiquated as mine (2002), the ALT-X method does not work like in Word
etc.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not