The four categories of operators are listed in the table below.
#Quattro pro spreadsheet converter pro#
The operators used in formulas tell Quattro Pro what to do with the data and functions. As a formula, however, what it does is increment the value of x. The familiar x=x+1 is a classic example for a formula that could never be a valid equation. In this respect they are similar to the formulas used in programming languages where the equals sign really means "assign the value of the expression on the right to the variable on the left". Calculations do not simply proceed from left to right.įormulas are not equations as only one side of the equals sign is used. Precedence - the order in which the calculations are done.For example, the formula =(2+3) returns the sum 5 while the formula =(2=3) returns a value of 0 because the statement is false. Context of operators – operators such as = can have different meanings depending on where they appear in the formula.Formulas are simple (usually) procedures which return the value or text that are displayed in the cell. Writing formulas is therefore a fundamental part of working with spreadsheets and is almost as easy as writing equations except that one must always remember three things: They are used to perform mathematical calculations, string operations, and logical operations on your data, can be a simple as ordinary arithmetic to complicated formulas involving many arguments, and even user-defined or third-party functions written in Microsoft VisualBASIC. Preventing Overflow Errors and Minimizing Numerical Errorsįormulas are the heart of your spreadsheet application.Using functions and graphing the results are addressed in later tutorials.
After completing these exercises you should be able to write any formula and, using the data entry and formatting lessons from previous tutorials, to create a useful and attractive spreadsheets. The exercises in this tutorial cover writing formulas that use the standard arithmetic and logical operators. It covers the basics of writing formulas, the types of operators available, reviews the concept and rules of precedence, gives some examples, and introduces a couple of features in Quattro Pro that can make writing and using formulas easier. This tutorial focuses on formulas, those mathematical and logical routines that you enter in the cells of a spreadsheet and which do the calculations. Quattro Pro Tutorial Working with Formulas