Formulas tab in Sheets

Formulas tab in Sheets Windows

The Formulas dropdown includes all of the controls needed to manage your spreadsheet formulas effectively.

	More Functions – Contains a list of all the formulas available in OfficeSuite alongside detailed descriptions of their functionality:
	Common – Contains more commonly used formulas, like AVERAGE and SUM. All – Displays the full list of formulas currently available in OfficeSuite. Database – Contains database-related formulas such as maximum and minimum database values or extracting records from a database. Information – Informational formulas allow you to make adjustments based on cell conditions, such as whether cells contain even numbers, return errors, and others. Logical – Logical arguments are those that can manage values like true/false. Maths– Contains mathematical formulas, including trigonometric functions and logarithms. Date & Time – Lets you write formulas that operate based on date and time parameters. Statistical – Provides formulas found in statistics like standard deviation and frequency. Financial – Finance formulas include calculating interest payments and depreciation. Reference – Allows you to look up references and values of a cell range. Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more. Compatibility – Provides a wide selection of variance and distribution formulas.
	Define Name... – Lets you name a particular cell or cell range, its range, and which sheets make up its scope.
	Name Manager... – Displays all of the named cells and cell ranges in the spreadsheet.
	Recalculate – Forces the selected formula to be recalculated. Useful for applying changes made to updated formulas and cells.
	Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result. Using this with only one cell selected will provide the sum of the above cell only.

Was this article helpful?

0 out of 3 found this helpful