Excel Formulas
Formula to calculate area of square
Formula to calculate area of rectangle
Formula to calculate area of circle
Text Formulas
CHAR Formula to find out character from ascii value
FIND Formula to find string within a string
Formula LEFT to find characters from left side
Formula to find length of string LEN function
Formula to convert string into lowercase LOWER function
Formula to find string within a string MID Function
Formula to convert first letter of all words to Capital Letter in a string
REPLACE formula to replace text within a string with new text
Formula REPT to repeat a text for a number of times
RIGHT Formula to find number of alphabets from right side
Formula SEARCH to find string within a string
Formula SUBSITUTE to replace text in a string with some other text
Formula TRIM to trim spaces from left and right side in a string
UPPER Formula to convert string to upper case
Math Functions
Formula to find absolute value ABS
CEILING.MATH Formula
Formula EVEN to find next even number from a given number
Formula FACT to calculate Factorial of a number
FLOOR.MATH Formula
GCD Formula to calculate GCD of two numbers
LCM Formula to calculate LCM of two numbers
MOD Function calculate remainder of two numbers
Formula ODD to calculate next ODD Number from a given number
Formula to get value of pi
POWER Formula to get a raise to the power of b
PRODUCT Formula to get product of two numbers
QUOTIENT Formula to get quotient of two numbers
RAND Formula to get a random value
RANDBETWEEN Formula to get random value between two numbers
ROMAN Formula to get roman value of a number
ROUND Formula to round off a number to specific number of decimal places
SIGN Formula to get sign of a number sign of negative number is -1 sign of positive number is 1 and
sign of 0 is 0
SQRT Formula to calculate square root of a number
SUM Formula to calculate sum of two numbers
TRUNC Formula to truncate a number to specific decimal places
DATE/TIME Functions
DATE Formula to get a date from year month and day
DAY Formula to get day from date
DAYS Formula to get number of days between two dates
HOUR Formula to get hour from time
MINUTE Formula to get minute from time
MONTH Formula to get month from date
NOW Function to get current date and current time on computer
SECOND Formula to get second from time
TIME Formula to get time from hour minute and second
TODAY Formula to get today's date
WEEKDAY Formula to get weekday from date
YEAR Formula to get year from a date
Logical Functions
IF Formula
OR Formula
NOT Formula
