write the name of some operators used in ms- excel
Answers
Answer:
Operators in Excel specifies the type of calculation to be performed on a given set of values. obviously not restricted to numeric values only, we can use operators over different data types other than numeric (for example, Text/Character data type). Excel has a rich variety of operators to perform calculative actions on a given set of data. In this article, we will see what the different types of Excel operators are and how those can be used to make your day to day life easy.
Answer:
The formula
Produces
Explanation
= "1"+"2"
3
When you use a plus sign (+), Excel expects numbers in the formula. Even though the quotation marks mean that "1" and "2" are text values, Excel automatically converts the text values to numbers.
= 1+"$4.00"
5
When a formula expects a number, Excel converts text if it is in a format that would usually be accepted for a number.
= "6/1/2001"-"5/1/2001"
31
Excel interprets the text as a date in the mm/dd/yyyy format, converts the dates to serial numbers, and then calculates the difference between them.
=SQRT ("8+1")
#VALUE!
Excel cannot convert the text to a number because the text "8+1" cannot be converted to a number. You can use "9" or "8"+"1" instead of "8+1" to convert the text to a number and return the result of 3.
= "A"&TRUE
ATRUE
When text is expected, Excel converts numbers and logical values such as TRUE and FALSE to text.