Needing simple formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Connie Martin - 25 May 2006 14:16 GMT

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

Reply to this Message

Bob Phillips - 25 May 2006 14:20 GMT

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

Signature

HTH

Bob Phillips

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

> 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

Reply to this Message

Connie Martin - 25 May 2006 14:32 GMT

Thank you! That works perfectly!

> =IF(LEFT(G3,1)="3","ZMO","")
>
[quoted text clipped - 5 lines]
> >
> > Connie

Reply to this Message

Andy - 25 May 2006 14:25 GMT

Hi

In H3, try:
=IF(LEFT(G3,1)="3","ZMO","")

Hope this helps.
Andy.

>I know it's simple, but I don't know how to write it. G3 contains a
>number.
[quoted text clipped - 3 lines]
>
> Connie

Reply to this Message

Connie Martin - 25 May 2006 14:33 GMT

Thank you! You and Bob have the exact same answer and it works perfectly!

> Hi
>
[quoted text clipped - 11 lines]
> >
> > Connie

Reply to this Message

Duke Carey - 25 May 2006 14:29 GMT

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

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

> 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

Reply to this Message

Connie Martin - 25 May 2006 14:58 GMT

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!

> =if(left(G3,1)="3","ZMO","")
>
[quoted text clipped - 5 lines]
> >
> > Connie

Reply to this Message