Excel Functions Arguments

Home » What Are Arguments In Excel » Excel Functions Arguments

Maybe your like

BetterSolutions.comBetterSolutions.com
  • Resources
  • Microsoft Office Word
  • VBA Programming
  • C# Programming
  • JavaScript Programming
  • Add-ins
  • Office Add-ins for Excel
  • Office Add-ins for Word
  • Consultancy
  • Macros, Templates and EUDAs
  • TypeScript and JavaScript
  • Development
  • Office JS Add-ins and Scripts
  • End User Programming
  • Support
  • VSTO and .NET Migration
  • Troubleshooting
  • Training
  • Microsoft 365 Integration
  • Contact Us Today for a FREE Consultation
  • Excel
      • Add-ins
      • Best Practices
      • Cells Ranges
      • Charts
      • Conditional Format
      • Data Analysis
      • Data Validation
      • Dates Times
      • Search Excel ...
      • Functions
      • User Defined
      • Formulas
      • Formatting
      • Illustrations
      • Importing
      • Layout
      • Macros
      • Our Services ...
      • Named Ranges
      • Options
      • Pivot Tables
      • Power Automate
      • Protection
      • Python
      • Reviewing
      • Ribbon
      • Find Add-ins ...
      • Rows Columns
      • Shortcut Keys
      • Tables
      • Templates
      • Track Changes
      • Workbooks
      • Worksheets
      • XML
      • Contact Us ...
  • Word
      • Add-ins
      • Bookmarks
      • Building Blocks
      • Bullets
      • Characters
      • Charts
      • Content Controls
      • Design
      • Search Word ...
      • Documents
      • Fields
      • Illustrations
      • Importing
      • Layout
      • Macros
      • Mailings
      • Numbering
      • Our Services ...
      • Options
      • Outlines
      • Pages
      • Paragraphs
      • Protection
      • References
      • Reviewing
      • Ribbon
      • Find Add-ins ...
      • Sections
      • Shortcut Keys
      • Styles
      • Tables
      • Templates
      • Text Boxes
      • Track Changes
      • XML
      • Contact Us ...
  • PowerPoint
      • Add-ins
      • Animation
      • Bullets
      • Characters
      • Charts
      • Design
      • Handouts
      • Illustrations
      • Search PowerPoint ...
      • Importing
      • Layout
      • Macros
      • Notes
      • Numbering
      • Options
      • Outlines
      • Paragraphs
      • Our Services ...
      • Presentations
      • Protection
      • References
      • Reviewing
      • Ribbon
      • Sections
      • Shortcut Keys
      • Slide Show
      • Find Add-ins ...
      • Slides
      • Tables
      • Templates
      • Text Boxes
      • Track Changes
      • Transitions
      • Video
      • XML
      • Contact Us ...
  • Outlook
      • Add-ins
      • Address Book
      • Alerts
      • Appointments
      • Calendar
      • Contacts
      • Events
      • Exchange
      • Search Outlook ...
      • Folders
      • Forms
      • Groups
      • HTML
      • Illustrations
      • Importing
      • Journal
      • Macros
      • Our Services ...
      • Mail
      • Meetings
      • Notes
      • OneDrive
      • OneNote
      • Options
      • People
      • Proofing
      • Find Add-ins ...
      • Ribbon
      • Rules
      • Search
      • SharePoint
      • Shortcut Keys
      • Tasks
      • Web Client
      • XML
      • Contact Us ...
  • VBA
      • Add-ins
      • Arrays
      • Best Practices
      • Class Modules
      • Code Snippets
      • Collections
      • Controls
      • Databases
      • Search VBA ...
      • Data Types
      • Dates Times
      • Debugging
      • Enumerations
      • Error Handling
      • Events
      • Files Directories
      • Functions
      • Our Services ...
      • Macros
      • MsgBox
      • Numbers
      • Options
      • References
      • Ribbon
      • Shortcut Keys
      • SQL
      • Find Add-ins ...
      • Strings
      • Subroutines
      • Syntax
      • Userforms
      • Variables
      • Visual Basic Editor
      • Web Interaction
      • XML
      • Contact Us ...
  • C#
      • .NET Library
      • Arrays
      • Best Practices
      • Classes
      • Collections
      • Databases
      • Data Types
      • Dates Times
      • Search C# ...
      • Debugging
      • Excel Interop
      • Error Handling
      • Files Directories
      • Generics
      • Interfaces
      • MessageBox
      • Numbers
      • Our Services ...
      • Projects
      • Serialization
      • Strings
      • Structures
      • Syntax
      • Threading
      • Variables
      • VBA Migration
      • Find Add-ins ...
      • Visual Studio
      • VSTO Add-ins
      • Web Add-ins
      • Web Development
      • Web Services
      • Windows Forms
      • WPF Forms
      • XML
      • Contact Us ...
  • JS
      • Arrays
      • Custom Functions
      • Data Types
      • Dates Times
      • Debugging
      • Dialog Boxes
      • Error Handling
      • Excel API
      • Search JavaScript ...
      • Express Backend
      • Fluent UI
      • Functions
      • HTML Pages
      • Microsoft Graph
      • Node JS Runtime
      • Numbers
      • Objects
      • Our Services ...
      • Office Add-ins
      • Office Events
      • Office Manifest
      • Office Scripts
      • Outlook API
      • PowerPoint API
      • React Library
      • Ribbon Commands
      • Find Add-ins ...
      • Strings
      • Syntax
      • Task Panes
      • TypeScript
      • Variables
      • Visual Studio Code
      • Word API
      • Yeoman Generator
      • Contact Us ...
PreviousNextExcel > Functions
  • Microsoft Excel
  • Functions
  • User FAQs ...
  • Inserting ...
  • Arguments
  • AutoCalculate
  • AutoSum
  • AutoComplete
  • Automatic Spill
  • Nesting
  • Editing
  • Complete List
  • Alphabetical A - M ...
  • Alphabetical N - Z ...
  • Categories ...
  • Counting Functions ...
  • Summing Functions ...
  • Lookup Functions ...
  • Data Functions ...
  • Lambda Functions ...
  • Advanced Functions ...
  • User Defined Functions ...
  • Translations ...
  • Google Sheets ...
  • LibreOffice Calc ...
  • Updates ...
  • Code - VBA ...
  • Updated: 12 December 2025
  • 12 December 2025
Arguments

Arguments can be numbers, text, cell references, named ranges, arrays, formulas or even other functions.Any arguments that are displayed in bold are required. The other arguments are optional.

If you insert a formula as an argument to a function you do not need to insert another equal sign (=). This is only necessary at the start of a formula.If you want to insert a function as an argument to another function, this is referred to as a nested function and is covered in detail on the next page.You can either type in the arguments directly or if the arguments are cell references you can select or drag the mouse over the relevant cells.Displaying the function parentheses, commas and argument names can be useful is you are unfamiliar with the function arguments.Pressing (Ctrl + Shift + A) when the insertion point is to the right of a function name will display this information.

Pressing (Ctrl + A) after you enter the name of function (e.g. =sum) will display the Function Arguments dialog box.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext

Tag » What Are Arguments In Excel