The Undergraduate Advising Office is here to help you find answers. Our advisors have prepared a list of Frequently Asked Questions about courses and credits. If you don't find an answer to your question there, please contact the advising office by emailing bioadv@indiana.edu or calling (812) 855-3810.he Undergraduate Advising Office is here to help you find answers. Our advisors have prepared a list of Frequently Asked Questions about courses and credits. If you don't find an answer to your question there, please contact the advising office by emailing bioadv@indiana.edu or calling (812) 855-3810.
If a cell contains a specific text than return a value Everywhere I search I see this formula for looking in a column and if a row contains a specific value then to return x, if not return y. =IF(ISNUMBER(SEARCH(text, A1)),X,Y) But when I use this in Excel 2010 I get an error. I modify it to look like this...
If you want to test a cell and take some action if the cell is blank (empty), you can use the IF function. In the example shown column D contains a date indicating when a task was completed. In column E, a formula checks for blank cells in column D. If a cell is blank, the result is a status of Open. If the cell contains a value (a date in this case, but it could be any value) the formula assigns status of Closed. The formula in cell E5 is: