These functions calculates the average of numbers in a range of data
Tag: Microsoft
COUNT – COUNTA – COUNTIF – COUNTIFS Function in Excel
These functions count the number of cells in a range that contains numerical values, or any values or if its equal to a some criteria
ROUND ROUNDUP ROUNDDOWN functions in Excel
These functions will convert a decimal number into an integer or another decimal number with desired decimal point
RAND and RANDBETWEEN functions in Excel
These two functions will return the a random number in Excel, RAND function will return a decimal random number between 0 to 1 and RANDBETWEEN will return an integer random number between two defined values
SUM, PRODUCT and SUMPRODUCT in Excel
Here we talk about all different type of sum functions in Excel
WeekNum and WeekDay functions in Excel
WEEKDAY, WEEKNUM in Excel These functions will return the week number from the start of year and the day name of the week at specific date
DAYS, NETWORKDAYS and DATEDIF functions in Excel
These functions will return the number of days between two dates
HOUR , MINUTE and SECOND functions in Excel
These functions will extract a hour , minute or second value from a time serial number in Excel as integer number
YEAR , MONTH and DAY functions in Excel
These functions will extract a year, month or day value from a date serial number in Excel as integer number
TODAY and NOW functions in Excel
TODAY and NOW functions return current time of your system and will keep it update in your Excel file: