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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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

JTL9161
  • Question Question
Need to cells with no data but with a formula
Replies
5
Views
99
Peter_SSs
Peter_SSs
D
  • Question Question
How to use If Statement or Vlookup when comparing lists of names
2
Replies
13
Views
475
Peter_SSs
Peter_SSs
S
  • Question Question
If statement
Replies
3
Views
122
etaf
etaf
M
  • Question Question
City State Zip Extraction
Replies
1
Views
193
Joe4
Joe4
R
  • Solved
How to ignore Blank cells in formula and not to show any data
Replies
5
Views
169
Alex Blakenburg
A

Forum statistics

Threads
1,224,813
Messages
6,181,117
Members
453,021
Latest member
Justyna P

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