If Statement Help

N

nolanstern

Board Regular
Joined
Aug 21, 2008
Messages
57
Hello,

I have one cell which contains 4 different words and want to do an if statement which shows when the word comes up then leave a blank cell.


Please reply with if statement.

Chris
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
Do you want to just check for one word?
Also what should the formula output if the word is found?
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
How to use If Statement or Vlookup when comparing lists of names
2
Replies
13
Views
458
Peter_SSs
Peter_SSs
S
  • Question Question
If statement
Replies
3
Views
108
etaf
etaf
M
  • Question Question
City State Zip Extraction
Replies
1
Views
116
Joe4
Joe4
W
  • Solved
IF statement to return different words for condition A, condition B, or both A and B.
Replies
6
Views
189
Fluff
Fluff
G
  • Question Question
Stop sort after data is sorted with button
Replies
6
Views
136
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,886
Messages
6,175,191
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top