Whenever you select a cell you will get to see a green box surrounds that specific cell. The Excel IF Statement function tests a given condition and returns one value for a TRUE result and another for a FALSE result. Excel uses a default order in which calculations occur.
To enter this formula in cell C2 follow these steps.
In Excel the Table format can help you to fill the above formula into the new inserted blank rows automatically please do as follows. To add a new function position your insertion point after the End Function statement that terminates the last function in the Code window and begin typing. You will see B2-C2 in the D2 cell as shown in the below screenshot. Double-Clicking the Fill Handle.