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.
The following formula will help: Total * Percentage = Amount. Assuming that the total value is in cell A2 and percent in B2, the above formula turns into a simple =A2*B2 and returns 104.50. Remember, when you type a number followed by the percent sign (%) in Excel, the number is interpreted as a hundredth of its value.hen calculating a percent in Excel, you do not have to multiply the resulting fraction by 100 since Excel does this automatically when the percentage format is applied to a cell. And now, let's see how you can use the Excel percentage formula on real-life data.