Hi

If it doesn't work, what result/error are you getting?

Andy.

"donnaK" wrote in message
...
Excel 2000 This function simply does not work. This function is in Cell
B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance