Use the forward slash as the division operator. This formula divides the value in cell A1 by the value in cell B1. In Excel there is no specific function for the division.
IFERROR E2F2 which indicates we have used dividend number 20 divisor number 5 which will give us the output of.
How to remove divide by zero errors DIV0 in Excel. What if I want to divide cell D5 by cell B4 and then roundup. Before we start lets look at the symbols that represent the basic arithmetic functions in Excel. Replace A1 and B1 with the actual cell locations you want to divide.