# Add a new formula that uses entered values

- Open a job in the Manage Estimates screen.
- From any tab, click Calculator .
- Click Formulas.
- In the Convert from Units field, click to select the unit that you want to convert from in the new formula.
- Verify that the formula you want to create does not appear in the list of formulas.
- Click New.
- In the Name field, enter a descriptive name for the formula.
- In the Description field, enter a detailed description of the formula.
- In the spreadsheet area, enter instructions for using each cell in the formula and clarifying instructions as needed.
- Enter 0 (zero) in each cell where you want users to enter information.
- To change the shading of a cell in the worksheet area, click on the cell and click Toggle. Instruction cells must be gray and data entry cells must be white.
- In the Answer area, enter a description for the result in the Description field.
- In the Unit field, enter the unit for the result.
- In the Formula field, enter the mathematical formula to generate the result. Use coordinates (for example, B1) to reference the cells in the spreadsheet area.
- When you finish entering the formula, click Test to test the formula with a working total value of 10.10.
- The filled in area of the spreadsheet is displayed. Follow your instructions in the gray cells and enter values in the white cells.
- Click OK.
- Once you have finished testing the formula, click OK.
- Click Cancel.
- Click Cancel.