Enter Formulas


Entering formulas in a worksheet is the same as most spreadsheets. Begin a formula by typing the equal sign (=). Now, you can click in any other cell to use the contents of that cell in your calculation. For example, to add the contents of two cells…

  1. In WinTOTAL’s worksheet tools, select the cell that you want to contain the calculation and press the = key on the keyboard.
  2. Click on the cell containing the first number you want to add, and then type the plus sign (+) on your keyboard.
  3. Click on the cell containing the second number and press Enter. The sum of the two numbers then displays in the cell.
  Note: The cells you’re adding may be linked to data in your form or other cells in which you’ve manually entered numbers.  
  Hint: Not all formulas are as simple as adding two fields. WinTOTAL worksheets support most of the mathematical, statistical and text handling formulas found in MS Excel. If you’re building a complex, multipart formula, it is often easier to create that formula in MS Excel. Then you can save the Excel spreadsheet and load it into WinTOTAL and create the desired links to and from your spreadsheet. This allows you to use Excel’s formula help and troubleshooting tools to fine tune your formula.