Wet_Blanket
Registered User.
- Local time
- Today, 13:34
- Joined
- Dec 3, 2008
- Messages
- 113
Access has rotten my brain. Whenever I need to write a formula in Excel, it is a challenge to remember.
All I want to do is create an IF THEN statement that recognizes words within a colum. The idea is that when "Pension" appears in a column, it would do something. But "Pension" only appears when it is part of a name, ie. ABC Company Pension.
What I have is:
=IF(E38="Pension",E38," ")
This of course doesn't work. I've tried many different things, but I can't remember the variable key for Excel.
All I want to do is create an IF THEN statement that recognizes words within a colum. The idea is that when "Pension" appears in a column, it would do something. But "Pension" only appears when it is part of a name, ie. ABC Company Pension.
What I have is:
=IF(E38="Pension",E38," ")
This of course doesn't work. I've tried many different things, but I can't remember the variable key for Excel.