Needing simple formula
Thank you! That works perfectly!
"Bob Phillips" wrote:
=IF(LEFT(G3,1)="3","ZMO","")
--
HTH
Bob Phillips
(replace somewhere in email address with googlemail if mailing direct)
"Connie Martin" wrote in message
...
I know it's simple, but I don't know how to write it. G3 contains a
number.
If G3 starts with a 3 then it's to yield "ZMO" in H3. If it's anything
else,
H3 is to be blank.
Connie
|