Wordperfect Quattro Pro

Working with formulas

Using Quattro Pro, you can create math formulas. The following characters are used when creating a formula:

As well, a formula can use any of the following arguments:

You create formulas using cell data, such as column totals.

You can also create text formulas. Text formulas are any formulas that have a textual result.

Quattro Pro also allows you to create logical formulas that evaluate true or false. For example, the result of the formula +C3<10 displays either 1 or 0 depending on the value of cell C3.

Displaying error sources directly in your cells shows you the cause of any problem with your formula. As well, you can convert formulas to values; the value appears in the cell and the input line, replacing the formula.

For additional information about creating formulas, see “Operator precedence”, “Guidelines for solving errors in formulas”, and “Working with arrays”.

To create a math formula

To create a formula from cell data

•

If the cell containing the data has a cell name, you can type the name into the formula instead of clicking on the cell. Make sure the insertion point for the name is to the right of an operator or opening parenthesis in the formula. To create a text formula 1.   Type a plus sign (+) in a blank cell. 2.   Type the formula using an ampersand (&) to combine text strings. For example,+C4&”Review” enters the text in cell C4, then the word Review. 3.   Press Enter. •   If you want to add a space between strings, type it inside the quotation marks. For example,+C4&” Review” enters the text in cell C4, a space, then the word Review. To create a formula that evaluates to true or false 1.   Click a blank cell. 2.   Type a formula using one of the logical operators. 3.   Press Enter. •   If the statement is true, a 1 displays in the cell. If the statement is false, a 0 displays. •   For an explanation of operators, see “Operator precedence.” To display error sources in cells 1.   Click Format Notebook properties. 2.   Click the Recalc settings tab. 3.   Enable the Audit errors check box. •   When you enable the Audit errors check box, each problem cell displays the sheet and cell reference where the problem started. The notebook name is included if the problem cell is in another notebook. To convert a formula to a value 1.   Select a cell containing a formula. 2.   Click Edit Convert to values. 3.   Type the destination cells in the To box. •   To replace a formula in a cell with its value, specify the same cells in the To box as are in the From box. • &nbs p; To copy the value of a formula to another part of the notebook, specify the top-left cell to which you want to copy the value. •   You can also specify the addresses of the destination cells by clicking the Range picker to the right of the relevant box and selecting a cell. Working with formulas Wordperfect Quattro Pro > Working with formulas Welcome to Quattro Pro Help Getting started with Quattro Pro Welcome to Quattro Pro What’s new in WordPerfect Office X5? Using the WordPerfect Office X5 setup Registering WordPerfect Office X5 Updating WordPerfect Office X5 Migrating from earlier versions of WordPerfect Office About Corel Support Services About customer feedback About Corel Learning to use Quattro Pro Using the documentation Getting additional help Accessing information on the Corel Web site Using Web-based resources Quattro Pro basics Understanding the components of a notebook Working with toolbars Working with the application bar Viewing notebook information Recording notebook summary information Working with Quattro Pro Experts Quitting Quattro Pro Reference: Quattro Pro basics Quattro Pro Accessibility features Using Accessibility features Accessing Quattro Pro documentation in ASCII text format Customizing keyboards, toolbars, and menus Modifying display and navigational features Changing the text size of the Help Compatibility with Microsoft Excel Using compatibility features Changing compatibility options Quattro Pro compatibility with Microsoft Excel Comparing Microsoft Excel and Quattro Pro features Simulating the Microsoft Excel workspace Sharing Quattro Pro spreadsheets with Microsoft Excel users Reference: Moving between Microsoft Excel and Quattro Pro Quattro Pro compatibility FAQ Opening and saving files Creating the equivalent of a Microsoft Excel PivotTable Using macros Opening Microsoft Excel templates Converting currency formats Creating and managing spreadsheets Creating spreadsheets Creating and opening notebooks Adding and deleting spreadsheets Moving and copying spreadsheets Renaming spreadsheets Selecting cells, rows, and columns Inserting and deleting cells, rows, and columns Creating labels and special characters Entering values Filling cells and spreadsheet tabs automatically Creating a series to fill cells Restricting and annotating cell data Creating simple equations Calculating data in rows and columns Using preset calculations Reference: Creating spreadsheets Working with project templates Creating projects by using templates Quattro Pro templates Working with project template categories Viewing and navigating spreadsheets and notebooks Navigating spreadsheets and notebooks Displaying, arranging, resizing, and hiding windows Zooming data and viewing screen components Hiding and revealing rows and columns Hiding notebook, spreadsheet, or screen components Working with data Managing files and data Opening and saving files Sending files Inserting, importing, and combining files Importing text into columns Linking and embedding objects Editing and updating objects and links Creating notebook links Editing and updating notebook links Sorting data Filtering data Consolidating data Working with outlines Protecting data Reference: Managing files and data Using WordPerfect Office file management Working with files and folders Previewing files Printing and viewing file lists Using the Favorites folder Mapping a network drive Viewing pages from the Web or an intranet Disabling the file management dialog boxes in WordPerfect Office Protecting files Editing and formatting spreadsheets Editing spreadsheets Checking spelling Editing cell content Undoing actions Editing grouped data Copying and moving cells, rows, and columns Using the writing tools Adding a Writing Tools language Using the spelling checker Using the thesaurus Using the dictionary Setting dictionary options Working with user word lists Changing the language settings Customizing the writing tools Reference: Using writing tools Formatting spreadsheets Resizing rows and columns Using formatting tools Wrapping text Joining cells Changing the appearance of text Working with fills, patterns, and borders Changing colors in the notebook palette Aligning data Working with numeric formats Creating custom formats Creating a bar format Working with page breaks Creating headers and footers Customizing margins Working with styles Reference: Formatting spreadsheets Working with formulas and functions Working with formulas Recalculating formulas Moving and copying formulas and referenced cells Composing formulas Working with spreadsheet functions Tracing errors in formulas Naming cells Reference: Working with formulas and functions Quattro Pro Functions List Quattro Pro Functions Categories Database spreadsheet functions Date and Time spreadsheet functions Engineering spreadsheet functions Financial spreadsheet functions Logical spreadsheet functions Mathematical spreadsheet functions Miscellaneous spreadsheet functions Statistical spreadsheet functions String spreadsheet functions Quattro Pro Functions Equivalents Analyzing data Using statistical analysis tools Creating frequency distribution tables Performing regression analysis Performing matrix operations Creating scenarios Managing scenarios Creating one-variable What-If tables Creating two-variable What-If tables Using goal seeking Finding optimum solutions for linear and nonlinear problems Reference: Analyzing data Summarizing data by using CrossTab reports Creating CrossTab reports Creating CrossTab reports by using OLAP data sources Creating CrossTab reports by using ODBC data sources Naming CrossTab reports Formatting CrossTab reports Updating and refreshing CrossTab report data Sorting and filtering CrossTab report data Moving and deleting CrossTab reports Customizing CrossTab report fields Hiding field items and details in CrossTab reports Calculating field summaries in CrossTab reports Performing field data comparisons in CrossTab reports Expanding, filtering, and removing field elements in OLAP CrossTab reports Making static copies of CrossTab reports Expanding CrossTab reports Using databases Creating notebook databases Preparing queries for searching notebook databases Querying notebook databases Querying external databases Importing data from external databases Refreshing data from external databases Reference: Using databases Working with charts and graphics Presenting spreadsheet data in a chart Plotting chart data Creating charts automatically Creating area charts Creating bar charts Creating bubble charts Creating Gantt charts Creating high/low charts Creating histogram charts Creating line charts Creating mixed charts Creating pie charts Creating polar charts Creating radar charts Creating scatter charts Creating spectral charts Creating surface charts Adding titles to charts Adding linked data to charts Working with chart series Changing chart data Changing the order of chart data Plotting a series on a secondary y-axis Changing bar chart options Changing line chart options Changing pie chart options Changing high/low chart options Changing the fill and border style of a chart series Changing the fill and border style of data points Replacing chart series with riser models Applying transparency and glow to a chart series Displaying data labels Working with chart text Selecting text Changing font appearance Applying fills to text Positioning, rotating, and moving text Adding boxes to text Adding fills to text boxes Setting the numeric format for chart text Editing chart text Formatting the x and y axes Displaying and positioning axis labels Setting the numeric format for the x and y axes Displaying and formatting gridlines Specifying scale properties Working with 3D charts Changing the viewing angle of 3D charts Managing viewing angles Changing the fill and border of 3D chart walls Editing charts Selecting chart items Changing chart types Changing legend labels and position Changing legend boxes and borders Applying fills to legend boxes Changing the fill and border of chart frames Changing the background fill Applying advanced rendering to charts Changing chart lighting Moving, resizing, and deleting charts Saving and retrieving chart templates Analyzing chart data Plotting trendlines Plotting error bars Reference: Analyzing chart data Adding graphics to spreadsheets Drawing shapes and lines Creating text box graphics Arranging graphics Viewing graphics Managing and sharing graphics Changing the properties of a shape Working in the Draw Picture window Using Scrapbook Starting and quitting Scrapbook Working with Scrapbook items Searching for items in Scrapbook Working with Scrapbook categories Previewing sound and movie files in Scrapbook Viewing items in Scrapbook Updating Scrapbook items Reference: Using Scrapbook Using TextArt Working with TextArt Using fonts and symbols Aligning and rotating TextArt images Changing the appearance of 2D TextArt images Changing the color and direction of light on 3D TextArt images Adjusting the bevel of 3D TextArt images Adjusting the resolution and texture of 3D TextArt images Using Equation Editor Creating equations Selecting equations Moving equation elements Formatting equation elements Setting default spacing of equation elements Adding nonmathematical phrases to equations Deleting equation elements and equations Adding equations to the list of preset equations Creating matrices in equations Reference: Equation Editor Palettes Troubleshooting Adding maps to spreadsheets Creating and positioning maps Presenting data on maps Editing maps Customizing map legends Reference: Adding maps to spreadsheets Sharing projects Working with PDF files Publishing to PDF Setting passwords for PDF files Creating PDF styles Working with fonts in PDF files Modifying PDF settings Optimizing PDF files for the Web Creating spreadsheets for the Web Publishing spreadsheet data in HTML Setting HTML style options Using XML with Quattro Pro Working with Web queries Working with Web links Linking to Web graphics Reference: Creating spreadsheets for the Web Using passwords Using password protection Working collaboratively Sharing notebooks Comparing notebooks Reviewing notebooks Layout and printing Printing Setting up a printer Setting up a print job Previewing a print job Printing the active spreadsheet or notebook Controlling a print job Spacing a print job Printing data Printing charts and maps Printing selected print areas Printing headers and footers Printing headings Laying out a print job Saving, restoring, and naming default print settings Printing to a file Reference: Printing Automating tasks Using macros Recording and editing Quattro Pro macros Working with macro libraries Recording and editing PerfectScript macros Creating VBA macros Debugging and editing a VBA macro Using the PerfectScript class to change a Quattro Pro document Working in Developer mode Recording macros that use relative or absolute cell references Attaching macros to notebooks and buttons Playing macros Debugging Quattro Pro macros Debugging PerfectScript macros Using macros to customize application settings Reference: Using macros Using OLE automation Using Quattro Pro with Lotus Notes Reference: Using OLE automation Using form controls Creating controls on a spreadsheet Customizing and managing controls on a spreadsheet Properties of form controls Using custom dialog boxes and controls Creating custom dialog boxes Editing and positioning dialog boxes Adding dialog box controls Assigning properties to dialog box controls Attaching actions to dialog box controls Editing and positioning dialog box controls Working with child controls in dialog boxes Creating Help and tips for controls Using macros to display a dialog box Reference: Using custom dialog boxes and controls Properties of dialog box controls Customizing Quattro Pro Changing program settings Changing the workspace Changing the display theme Customizing menus Customizing keyboards Changing currency and punctuation settings Setting a default language Using shortcut keys and startup switches Using shortcut keys Using startup switches Quattro Pro properties Understanding object properties Understanding cell properties Understanding property syntax Common properties Active Object properties Common Chart Object properties Drawn Chart Object properties Fixed Chart Object properties Dialog Control properties Menu Item properties Notebook Object properties Objects Sheet Icon properties Glossary Wordperfect Quattro Pro en Powered by Helpmax Guide Source