Excel TutorialLesson 5Free preview
Excel Syntax
This lesson is part of Excel · All levels
Summary
This lesson explains the syntax of the Excel formula: all the formulae start with the symbol =, continue with the name of the function, then the argument in the curve. The argument is separated by a comma and can be a value, a cell, a range, or another formula. When this pattern is broken, Excel displays errors such as #NAME? or #VALUE! that mark the wrong syntax.
Key points
- The formula must start with the sign =; without the sign the cell is considered a normal text
- General structure:
- The default Excel version of the argument separator is the comma (,)
- Error #NAME? denotes the name of the function or reference unknown
- A text cell that starts with a certain number or sign can use a quotation mark as part of the value
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.