Fresh Excel Tips

In this exercise we will be using the OR function to check cells for certain values. The formula will check column A for the text “fresh” or “excel” and return TRUE if it finds either word, otherwise, if the criteria is not met, it will return false. Here is how we will apply the OR Function.

How to use the OR Function to check cells for text

1. Enter your text in column A from A1:A10.
2. Select Cell B1 and type the following formula: =OR(A1=”fresh”,A1=”excel”)
3. Press Enter. Use the fill handle to copy the formula down to B10

The formula will return TRUE once it finds either “fresh” or “excel” in the cell, otherwise it will return FALSE. You can use a similar formula to check for numbers as well, just don’t include the quotes. Apply the principles discussed on this page to your own worksheet and you will find success! This should work in Excel 97, 2000, 2003 and 2007.

1. Combine Cells with text, date, time and numbers in Excel
2. How to Use the COUNTA function to count cells containing text
3. How to Check for Valid Numbers Using the T Function in Excel
4. How to Check Cells in Workbooks and Worksheets using Excel
5. How to Use the TEXT Function to format and combine text