Excel Functions

Syntax
ABS(number)
Number is the real number of which you want the absolute value

Example :-
=abs(-123)
result 123

And
Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.
=AND(A6<33,B6<33,C6<33)

if a6,b6 and c6 is less than 33 then it returns true else false

By using
if Command you can change true as good false as bad

=IF(AND(A6<33,B6<33,C6<33),"Good","Bad")

=AVERAGE(...,...,..,..)

Returns the average (arithmetic mean) of the arguments. For example, if the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.


AVERAGEIF(range,criteria,average_range)
Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
Average_range is the actual set of cells to average. If omitted, range is used.




CONCATENATE(text1, [text2], ...)
The CONCATENATE function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

text1  Required. The first text item to be concatenated.
text2 ...  Optional. Additional text items, up to a maximum of 255 items. The items must be separated by commas.
 Note    You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1).


COS(number)
Number is the angle in radians for which you want the cosine.


=COUNT(A1:A20)
In this example, if five of the cells in the range contain numbers, the result is 5.


COUNTIF(range, criteria)
The COUNTIF function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

range  Required. One or more cells to count, including numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.
criteria  Required. A number, expression, cell reference, or text string that defines which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".


FACT(number)
Number is the nonnegative number for which you want the factorial. If number is not an integer, it is truncated.


FLOOR(number,significance)
Number is the numeric value you want to round.
Significance is the multiple to which you want to round.


Creates a shortcut or jump that opens a document stored on a network server, an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.), or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file that is stored at link_location.

Syntax
HYPERLINK(link_location,friendly_name)


LEFT(text,num_chars)
LEFTB(text,num_bytes)
Text is the text string that contains the characters you want to extract.
Num_chars specifies the number of characters you want LEFT to extract.

• Num_chars must be greater than or equal to zero.
  
• If num_chars is greater than the length of text, LEFT returns all of text.
  
• If num_chars is omitted, it is assumed to be 1.