+ Reply to Thread
Results 1 to 4 of 4

If Statement issue

Hybrid View

Mike Shamrock If Statement issue 12-07-2006, 05:20 PM
Carim Hi Mike, ... 12-07-2006, 05:30 PM
Mike Shamrock Awesome! 12-07-2006, 05:39 PM
Carim Glad to see you are happy... 12-07-2006, 06:02 PM
  1. #1
    Registered User
    Join Date
    12-07-2006
    Posts
    15

    If Statement issue

    Can anyone please help me with an If Statement problem? (I hope so )

    I need to develop an if statement to return a value if a cell begins with a certain letter.
    For example:
    If b2 begins with the letter P return Perfect, if b2 begins with the letter G return Great, otherwise leave blank ("")

    Any help would be greatly appreciated.

    Mike Shamrock

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi Mike,

    =If(Left(B2,1)="P","Perfect",If(Left(B2,1)="G","Great",""))
    HTH
    Carim

  3. #3
    Registered User
    Join Date
    12-07-2006
    Posts
    15

    Awesome!

    Carim....super... I wish I could have thought of that, but very thankful you did!!

    Thanks
    Sham

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad to see you are happy ...!!!

    Thanks for the feedback

    Carim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1