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.
How To Count The Number Of Items Less Than The Average
read more
Formulas
How To Calculate The Area Of A Circle
This formula will calculate the area of a circle given its radius.
How To Add Leading Zeros To A Number
This formula will add leading zeros to a given number up to a specified number of total characters in the result.
How To Get The Percent Of The Year Completed
This formula will return the percent of the year completed for a given date.
How To Test If A Date Is On A Weekend
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.
How To Get The Weekday Name From A Date
This formula will return the weekday for a given date.
Get the Latest Microsoft Excel Tips
Follow Us
Follow us on social media to stay up to date with the latest in Microsoft Excel!