Alice oversees the day-to-day Advising Office operations; greets students; declares Biology minors; and answers questions regarding requirements, policies and procedures applicable to the Biology and Microbiology degrees, and any general requirement of the College.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.
Here's what this formula does: 1  First, it checks the contents of A2. 2  If A2 contains a number, the formula calculates A2*B2 and returns the result. 3  If A2 doesn't contain a number, the formula simply returns  - quote marks with nothing between them. In doing so, cell C2 appears to be empty.
Even in Excel 2003, there is no indication that the problem with the formula is too many IFs. If you have a requirement for more than 7, use VLOOKUP, instead. If the value in A1 is greater than 60, put a D in cell B2. If the value in A1 is greater than 70, put a C in cell B2. If the value in A1 is greater than 80, put a B in cell B2. If the value in A1 is greater than 90, put an A in cell B2. Otherwiseif none of the above conditions are metput an F in cell B2.