Type the equal sign followed by the constants and operators up to 8192 characters that you want to use in the calculation. Excel displays the calculated answer in cell C2 and the formula A2B2 in the Formula bar. Enter a number in cell A1.
Type any value in B3 and c3 cells you will see the answer in the D3 cell.
If a cell is blank the formula will assign the status open However if a cell contains a date then the formula will assign a status of closed The formula used is. Now you have applied the formula to every cell in the column. After selecting the cell A1 type plus sign and select the cell A2. Then click on the Insert tab.