View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin
 
Posts: n/a
Default 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