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.
Both those solutions work but format would hide the result if the sum of the cells is zero and I would guess you would want to show it the formula will show zero in the same circumstances.If the second didn't work then there is probably a number in the range, that's what count does, it counts numbers.oth those solutions work but format would hide the result if the sum of the cells is zero and I would guess you would want to show it the formula will show zero in the same circumstances.