Formulas tab in Sheets

Formulas tab in Sheets Android

Formulas are part of the core functionality of spreadsheets, and the Formulas tab includes all of the controls needed to effectively manage your formulas.

	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 allow you to enter cell ranges manually.
	Financial – Finance formulas include calculating interest payments and depreciation.
	Logical – Logical arguments are those that can manipulate values like true/false.
	Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more.
	Date & Time – Lets you write formulas that operate based on date and time parameters.
	Reference – Allows you to lookup references and values of a cell range.
	Math – Contains mathematical formulas including trigonometric functions and logarithms.
	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.
	Insert Function – 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. Math & Trig – Contains mathematical formulas including trigonometric functions and logarithms. Logical – Logical arguments are those that can manipulate values like true/false. Statistical – Provides formulas found in statistics like standard deviation and frequency. Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more. Reference – Allows you to lookup references and values of a cell range. Date & Time – Lets you write formulas that operate based on date and time parameters. Finance – Finance formulas include calculating interest payments and depreciation. Information – Informational formulas allow you to make adjustments based on cell conditions, such as whether cells contain even numbers, return errors, and others. Database – Contains database-related formulas such as maximum and minimum database values or extracting records from a database.