If cell contains a certain letter.

**valks1** · 11-19-2020, 03:44 PM

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.

**Sam Capricci** · 11-19-2020, 03:52 PM

your workbook is password protected.

**valks1** · 11-19-2020, 04:19 PM

Password Connell1

**Sam Capricci** · 11-19-2020, 04:35 PM

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

**valks1** · 11-19-2020, 05:13 PM

Thank you Sam.

If cell contains a certain letter.

LinkBack

Thread Tools

Rate This Thread

Display

If cell contains a certain letter.

Re: If cell contains a certain letter.

Re: If cell contains a certain letter.

Re: If cell contains a certain letter.

Re: If cell contains a certain letter.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change last letter in active cell to next incremental letter

searching for letter a in a table of numbers and output all cols related to that letter a

[SOLVED] How to separate single letter first name & multiple letter first name in excel'10 column?

Split cell containing a lowercase letter followd by an uppercase letter with no space b/w

[SOLVED]Order Code has 1 letter added need function to delete said letter

[SOLVED] Macro to Click on Alphabet Letter to go to Cell Where that Alphabet Letter Starts in Large Spreadsheet

if a cell = a particular letter or even contains that letter

Bookmarks

Bookmarks

Posting Permissions