# Formula ## Definition ### [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] >[! Definition] >A set of instructions used to perform a calculation using the data in a spreadsheet. ## Examples ### Strict formula ```Spreadsheet =2+2 ``` create a formula by beginning with an = operator. This tells the application that what follows is a formula ### Using [[Cell reference]] ```spreadsheet =(B2-F1)/A11 ``` ### Spreadsheet Error Codes [[ERROR!]] [[DIV 0!]] [[NA Error]] [[NAME?]] [[NUM!]] [[VALUE!]] [[REF!]] ## Related [[Function]] [[Spreadsheet]] [[Operator]] ## Resources [Google Sheets formula error guide](https://www.benlcollins.com/spreadsheets/formula-parse-error/) [MS EXCEL error helper docs](https://support.microsoft.com/en-us/office/formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9?ui=en-US&rs=en-US&ad=US#id0eaabaaa=errors) ## Flashcards A set of instructions used to perform a calculation using the data in a spreadsheet. @@@ [[Formula]] <!--SR:!2024-11-27,15,290!2024-11-20,8,250-->