###
__Excel Formulas and Functions Cheat Sheet__

Microsoft Excel Formulas and Functions Cheat Sheet |

If
you are not using

**Microsoft Excel formulas and functions,**then you are making a mistake. If you learn something and start using it, then you can dramatically**increase your efficiency and speed up your workflow.****Excel is widely used today globally.**

**Excel helps to preserve data in a very systematic manner**. It not only

**allows us to organize the data,**but also uses detailed

**techniques to do extensive work on our data**. You can do a lot of

**mathematics and actually apply formulas**for

**large amounts of data without computing anything**. This is

**Power of Excel**and through it, you can

**greatly reduce the amount of time**that you would

**otherwise spend in the operation of data**if you do not

**know about Excel formulas.**

By
reading this article, you will be able to

**know about the various required formulas of Excel.**In this article, you will get a**list of Excel formulas,**which you can**customize to suit**your needs and by**adding formulas.**
But
who gets the time to study it? So why not use a shortcut and download this

**list in the PDF format and save it to your PC**, so that whenever you need it you can open it and use this**cheat sheet**.**Read More....**

Now
let's take an example to

**know how Cheat Sheet**will help you-### For example, in the cheat sheet below:

**Today () is a function that gives you the current date.**

**Today () + 5 is a function that adds 5 days to the current date.**

Term

**formula and function**are often used for each other, so we will use**"formula"**to avoid confusion in this**basic chit sheet**. Just remember, you**create your own formula**, while the functions are by default**fragments of code programmed in Excel.**Microsoft Excel Formulas and Functions Cheat Sheet |

### Microsoft Excel Formulas Cheat Sheet in English

###
__Formula
& description__

### Date and Time Excel Formula

**= NOW**shows

**date and time.**

**= TODAY ()**shows the

**current date without time**.

**= DAY (TODAY ())**

**Displays today's date in a cell.**

**= MONTH (TODAY ())**shows the

**current month in a cell.**

**= TODAY () + 10**shows the

**10 days by adding 10 days.**

###
**Counting and Rounding Formulas in Excel**

**= SUM**value the value A group.

**= AVERAGE**

**calculates the mean of group**A of value A.

**= COUNT**

**counts the number of cells**in the

**range that contains the numbers.**

**= INT**removes the

**decimal part of a number.**

**= ROUND**

**Rounds a number of decimal places to a specified number.**

**= IF**for

**true or false status.**

**= NOW**now shows

**date and time.**

**= TODAY**shows

**date without time.**

**= Sum**from the

**SUMIF group,**it values the value t, which has a condition fulfilled.

**= COUNTIF**

**counts the number of cells**in a range that matches a criteria.

**= COUNTA (A1: A5)**

**calculates the number of non-blank cells in a range.**

**= ROUND (1.45, 1)**Rounds 1.45 to a

**decimal places.**

**= ROUND (-1.457, 2) -1.457**Rounds to two

**decimal places.**

**= TRUE**

**logical value returns TRUE.**

**= FALSE**

**logical value returns to FALSE.**

**=AND Returns TRUE if all arguments are TRUE.**

**= OR Returns TRUE if any argument is TRUE.**

**Read More...**

###
**Unit Conversion Formulas in Excel**

**= Converts (A1, "day", "hr")**values of A1 "from

**days to hours.**

**= CONVERT (A1, "hr", "mn")**value of A1 from

**hours to minutes.**

**= CONVERT (A1, "yr", "day")**invests the value of A1 in

**years to days.**

**= CONVERT (A1, "C", "F")**Converts a value of A1 to

**Celsius to Fahrenheit.**

**= CONVERT (A1, "mi", "km")**value of A1 from

**miles to kilometers.**

**= CONVERT (A1, "km", "mi")**value of A1 from

**kilometers to miles.**

**= CONVERT (A1, "in", "ft")**value of A1 from

**inches to feet.**

**= CONVERT (A1, "cm", "in")**value of A1) from

**centimeters to inches.**

**= BIN2DEC (1100100)**

**binary**calls 1100100 into

**decimal**(100).

**= ROMAN**

**converts a number into Roman numeral**

**Mathematics.**

**= A2-D9**

**subtracts the values n to two cells-.**

**= D8 * A3 multiplies the value of two cells-.**

**= PRODUCTS (A1: A19) multiply cells in range.**

**= PRODUCT (F6: A1,2) Multiplying cells in range, and multiplies the resultant to 2.**

**= A1 / A3 divides A1 from A3.**

**= The remainder from the MOD division.**

**= MIN (A1: A8)**

**calculates the smallest number in a range.**

**= MAX (C27: C34) calculates the largest number in a range.**

**= SMALL (B1: B7, 2) Calculates the second smallest number in a range.**

**= LARGE (G13: D7,3) calculates the third largest number in a range.**

**= POWER (9.2) calculates nine squares.**

**= 9 ^ 3 calculates the nine cube.**

**= FACT (A1)**

**removes the Factorial of the value**of A1.

**= EVEN**

**Rounds the number even closest even integer.**

**= ODD**Rounds the number to the nearest

**odd integer.**

**= AVERAGE**

**calculates the average.**

**= MEDIAN calculates median / middle.**

**= SQRT calculates the square root of a number.**

**= PI represents the value of the pie.**

**= POWER**

**calculates**the result of a number that is

**picked up for power.**

**= RAND**gives a

**random number between 0 and 1.**

**= RANDBETWEEN**Returns a

**random number between the numbers you specify.**

**= COS**

**calculates the cosine of a number.**

**= SIN**shows the sign of the given angle,

**calculates the sign of the given angle.**

**= TAN**

**calculates the tangent of a number.**

**= CORREL**

**calculates correlation coefficient between two data sets.**

**= STDEVA**

**estimates standard deviation**based on a sample.

**= PROB**gives the

**probability**that the

**values in a range are between two ranges.**

**Read More...**

###
**Text Formulas**

**= LEFT**

**text removes one or more characters**from the

**left side of the string.**

**= RIGHT**

**extract one or more characters**from the

**right of the text string.**

**= MID**

**removes the character ring**from the

**middle of a text string.**

**= CONCATENATE**

**adds two or more text strings.**

**= REPLACE Replaces part of text strings.**

**= LOWER Converts all text string to lowercase.**

**= UPPER Converts all text string to uppercase.**

**= PROPER converts string to proper case.**

**= LEN shows the length of the string in the text.**

**= REPT repeats the text up to the given number.**

**= TEXT creates a number format and converts it into text.**

**= VALUE Converts a text cell to a number.**

**= VALUE Convert text cell to number.**

**= Exact**

**checks whether two text values are identical**or not.

**= DOLLAR**uses the

**currency format, convert the number to text.**

**= Removes**all

**non-printable characters from the CLEAN text.**

###
**Finance**

**= INTRATE**

**calculates the interest rate**for fully invested security.

**= EFFECT**

**calculates effective annual interest rate.**

**= FV**

**calculates the future value of an investment.**

**= FVSCHEDULE calculates the future value**of an

**initial principal after applying a series of compound interest rates.**

**= PMT**

**Calculates Total Payments (Loan and Interest) on Loan Security.**

**= IPMT**

**calculates interest payments for investment for a fixed period.**

**= ACCRINT calculates interest earned for security paying periodic interest.**

**= ACCRINTM calculates interest earned for a security that pays interest on maturity.**

**= AMORLINC**

**calculates depreciation for each accounting period.**

**= NPV**

**calculates net present value of cash flows based on discount rate.**

**= YIELD calculates yield of a security based on maturity, face value and interest rate.**

**Read More...**

**Speed up your work in Microsoft Excel**

If
you refer to the above

**mentioned cheat sheet**, then you will become a**master nick in Excel.**
We
hope that

**after knowing this formula**, the**speed of working in your Excel will increase.**

__THANKS__###
__All Post NetKiDuniya__

__All Post NetKiDuniya__
We have given you great information, we hope that you will continue to provide such information even further. Read More...Microsoft Excel Formulas and Functions Cheat Sheet in English NetKiDuniya

ReplyDelete