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...
1 Therefore, the Indirect formula returns the value from cell E3.  In cell A4, the Indirect function returns a reference to the range C4:E4, and then passes this to the Excel SUM function. The SUM function therefore returns the sum of cells C4, D4 & E4 (i.e. 4 + 6 + 2).