Some well known Functions in Excel and their uses

Asked By Barb Brennan 20 points N/A Posted on - 11/25/2014

Name some functions in Excel and how I can use them? What is the purpose of the lookup function in EXCEL? What operation does the AND function perform? What is IF function in Excel? How is the “What If “condition used in Excel to give different answers when you change the data ?

• Status: Open
• Question Views: 559
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Neil Auso

Go To Solution

Answered By Nothman tale 0 points N/A #152209

Some well known Functions in Excel and their uses

Name of Function in Excel:

YEARFRAC function:

Return the years between start dates to end date.

YEAR Function:

Serial number convert into year.

WORKDAY function:

Return the working days.

WEEKDAY function:

Convert a serial number to a day.

VALUE function:

Convert a text in to number.



UPPER function:

Convert text in to uppercase form.

TYPE function:

Return the data type value.

TRUE function;

Return true if logical value is true.

TRIM function:

Remove the spaces from text.



Working of LOOKUP function:

Check the value that is in array or vector form.

Working of AND function:

Return true if given condition is true otherwise return false if given condition is false.

Working of IF function:

Return true if condition met otherwise return false.

About Nothman tale

Questions
0

Answers
77

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 12/29/2014
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Neil Auso 0 points N/A #152208

Some well known Functions in Excel and their uses

The LOOKUP function is used to returns a value either from a one-row or one-column range.  It has to syntax form 

1) Vectors 

2) Arrays.

These functions can be found on Microsoft website. You can also Google it to get best syntax.

About Neil Auso

Questions
0

Answers
117

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 12/30/2014
• Question Category: MS Excel