Need help with IF Function

August 16, 2011 at 09:19:24
Specs: Windows 7
I think I need to use an If Function for this. I want different calculations depending on what letter is listed in a certain cell. For example, I may want a certain calculation if a cell has an N in it. The problem is I also may need to calculate something if that same cell has the letter B in it. Therefore, I need it to be able say if there is a letter N in the cell, even if is NB or just N, it will calculate something. I may have up to 4 letters in one cell. Is this possible?

See More: Need help with IF Function

August 16, 2011 at 11:07:17
First, when posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Need Help Excel 2010" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

As for your question, try this:

=IF(ISERROR(FIND("N",A1)), "Don't Calculate Anything", "Calculate Something")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question