Needing simple formula

C

Connie Martin

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
 
B

Bob Phillips

=IF(LEFT(G3,1)="3","ZMO","")

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 
D

Duke Carey

=if(left(G3,1)="3","ZMO","")

Keep in mind that "" is NOT blank, it just displays as blank
 
C

Connie Martin

Thank you! That works perfectly!

Bob Phillips said:
=IF(LEFT(G3,1)="3","ZMO","")

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
Click to expand...
 
C

Connie Martin

You guys all know your stuff! You all have the exact same answer! Thank
you. I knew it was simple, but .... it's not one I've had to use until now.
Thanks again!
 
Top