This formula will take the average of a numerical range then return the count of the items in the range that are less than the average.
This formula will calculate the area of a circle given its radius.
This formula will add leading zeros to a given number up to a specified number of total characters in the result.
This formula will return the percent of the year completed for a given date.
This formula will test a given date to see if it’s a weekend (Saturday or Sunday) and return TRUE if it is a weekend and FALSE if it is not a weekend.
This formula will return the weekday for a given date.
Get The Latest News
Follow us on social media to stay up to date with the latest tips in Excel!