You can't use the same cell, you would need a help cell

=IF(OR(LEFT(C2)="A",LEFT(C2)="H"),1,"")



--
Regards,

Peo Sjoblom



"soconfused" wrote in message
...
I am trying to look at a cell and put a #1 in it:

Example Column C = A-LA41-09-92256 I need a formula
here
to put a # 1 if the value is A- or H-

Thanks in advance.

DMM