Here are the important symbols used in Excel Formulas. Each of these special characters have used for different purpose in Excel. Let us see complete list of symbols used in Excel Formulas, its meaning and uses.
What are the benefits of running multiple instances of Excel?-If you have 32-bit Excel, each instance can use up to 3 GB memory. If you have a powerful computer, very heavy files, and 32-bit Excel, each instance of Excel can use 3 GB. 2 instances of Excel.exe, you could say that the total memory Excel could use triples. With out them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas.
Symbols used in Excel Formula
Following symbols are used in Excel Formula. They will perform different actions in Excel Formulas and Functions.
| Symbol | Name | Description |
|---|---|---|
| = | Equal to | Every Excel Formula begins with Equal to symbol (=). Example:=A1+A5 |
| () | Parentheses | All Arguments of the Excel Functions specified between the Parentheses. Example:=COUNTIF(A1:A5,5) |
| () | Parentheses | Expressions specified in the Parentheses will be evaluated first. Parentheses changes the order of the evaluation in Excel Formula. Example: =25+(35*2)+5 |
| * | Asterisk | Wild card operator to to denote all values in a List. Example: =COUNTIF(A1:A5,”*“) |
| , | Comma | List of the Arguments of a Function Separated by Comma in Excel Formula. Example: =COUNTIF(A1:A5,“>” &B1) |
| & | Ampersand | Concatenate Operator to connect two strings into one in Excel Formula. Example: =”Total: “&SUM(B2:B25) |
| $ | Dollar | Makes Cell Reference as Absolute in Excel Formula. Example:=SUM($B$2:$B$25) |
| ! | Exclamation | Sheet Names and Table Names Followed by ! Symbol in Excel Formula. Example: =SUM(Sheet2!B2:B25) |
| [] | Square Brackets | Uses to refer the Field Name of the Table (List Object) in Excel Formula. Example:=SUM(Table1[Column1]) |
| {} | Curly Brackets | Denote the Array formula in Excel. World of warcraft chaos orb. Example: {=MAX(A1:A5-G1:G5)} |
| : | Colon | Creates references to all cells between two references. Example: =SUM(B2:B25) |
| , | Comma | Union Operator will combine the multiple references into One. Example: =SUM(A2:A25, B2:B25) |
| (space) | Space | Intersection Operator will create common reference of two references. Example: =SUM(A2:A10 A5:A25) |
You must be logged in to post a comment.
Excelx.com is a Excel Blog by PNRao to provide latest tips of Excel and help you to Quickly Learn and up-to date with Excel Concepts. We help you to know – how to do things in Excel with Clean and Easy Excel Tips, Shortcuts, Reference, Tutorials and New and Quick Tricks and Methods.
A person given to pretentious display. The act of showing off. Showoff. Definition of show off (Entry 2 of 2) transitive verb.: to display proudly wanted to show our new car off. Intransitive verb.: to seek to attract attention by conspicuous behavior boys showing off for the girls. Other words for showoff.
We Provide Free Online Tutorials, Formulas, Templates, Dashboards and Macros to excel in Microsoft Excel. We cover basic to advanced concepts and share creative ideas, Excel tips and Shortcuts with Related Example Files. You Can refer verity of examples covered on latest tools and techniques in Microsoft Excel Applications.
What Does Excellent Customer Service Mean
What Does Excellent Customer Service Mean
Related Posts