**To create and copy a formula using relative references:**

- Select the first cell where you want to enter the formula (B4, for example).
- Enter the formula to calculate the value you want (B2+B3, for example).
- Press Enter.
- Select the cell you want to copy (B4, for example), then click the Copy command from the Home tab.

Also know, how do you do the formulas in Excel?

**To create a simple formula in Excel:**

- Select the cell where the answer will appear (B4, for example). Selecting cell B4.
- Type the equals sign (=).
- Type in the formula you want Excel to calculate (75/250, for example). Entering formula in B4.
- Press Enter.

How do you write a conditional formula in Excel?

**To create the first rule:**

- Select cells A2 through A7.
- Then, click Home > Conditional Formatting > New Rule.
- In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
- Under Format values where this formula is true, type the formula: =A2>TODAY()
- Click Format.