HELP WITH FORMULAS AND RULES

NicoleM360 

You can use a combination of the IF and OR functions to achieve the first part of your goal. Here’s an example formula that you can use in cell D1 to check the value in cell A1 and return the corresponding text:

=IF(ISNUMBER(A1),"Does Not Release",IF(OR(A1="N/A",A1="n/a"), "N/A", IF(ISNUMBER(SEARCH("*",A1)), "Not Listed", "")))

This formula first checks if the value in cell A1 is a number using the ISNUMBER function. If it is, the formula returns the text “Does Not Release”. If the value in cell A1 is not a number, the formula then checks if it is equal to “N/A” or “n/a” using the OR function. If it is, the formula returns “N/A”. If the value in cell A1 is not equal to “N/A” or “n/a”, the formula then checks if it contains an asterisk (*) using the SEARCH function. If it does, the formula returns the text “Not Listed”. If none of these conditions are met, the formula returns an empty string (“”).

To apply strikethrough formatting to cells B1 and C1 if the value in cell A1 is “N/A” or “n/a”, you can use conditional formatting.

Here’s how you can do this:

1. Select cells B1 and C1.
2. Click on the “Home” tab in the ribbon.
3. Click on the “Conditional Formatting” button and choose “New Rule”.
4. In the “New Formatting Rule” dialog box, choose “Use a formula to determine which cells to format”.
5. In the formula field, enter =OR($A1="N/A",$A1="n/a").
6. Click on the “Format” button and choose the “Font” tab.
7. Check the “Strikethrough” option and click on “OK”.
8. Click on “OK” again to apply the conditional formatting rule.

This will apply strikethrough formatting to cells B1 and C1 if the value in cell A1 is equal to “N/A” or “n/a”.

I hope this helps! 

NikolinoDE

I know I don't know anything (Socrates)