+ Reply to Thread
Results 1 to 5 of 5

If cell contains a certain letter.

  1. #1
    Registered User
    Join Date
    04-08-2020
    Location
    uk
    MS-Off Ver
    office 360
    Posts
    9

    If cell contains a certain letter.

    Hi im hoping someone can help.
    This is what i need to happen.
    If the cell in column W2 contains the letter s then the value in cell Z2 needs to change to show SP
    I cant work this out because i have a formula in Z2 already.
    Attached Files Attached Files
    Last edited by valks1; 11-19-2020 at 04:18 PM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Re: If cell contains a certain letter.

    your workbook is password protected.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-08-2020
    Location
    uk
    MS-Off Ver
    office 360
    Posts
    9

    Re: If cell contains a certain letter.

    Password Connell1

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Re: If cell contains a certain letter.

    this looks like it should work for you...
    =IF(W2="s","SP",CEILING.MATH(X2,Y2))

  5. #5
    Registered User
    Join Date
    04-08-2020
    Location
    uk
    MS-Off Ver
    office 360
    Posts
    9

    Re: If cell contains a certain letter.

    Thank you Sam.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change last letter in active cell to next incremental letter
    By dwetzel01 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-28-2019, 12:08 PM
  2. Replies: 12
    Last Post: 07-19-2016, 11:25 AM
  3. Replies: 6
    Last Post: 03-30-2016, 04:28 PM
  4. Replies: 25
    Last Post: 04-21-2015, 10:19 AM
  5. [SOLVED]Order Code has 1 letter added need function to delete said letter
    By king10001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2013, 01:25 PM
  6. Replies: 2
    Last Post: 07-26-2005, 03:05 AM
  7. [SOLVED] if a cell = a particular letter or even contains that letter
    By Brian in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2005, 02:07 AM

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