Category: Formulas
How To Get The Weekday Name From A Date
This formula will return the weekday for a given date.
Read MoreHow To Get The Percent Of The Month Completed
This formula will return the percent of the month completed for a given date.
Read MoreHow To Do A Case Sensitive Lookup
This formula will perform a vertical case sensitive lookup in a given range of values and return a result from the corresponding cell in another range. The functionality of this formula is similar to the VLOOKUP function, however VLOOKUP does not differentiate between upper and lower case letters when looking for a match. To VLOOKUP “AAA” and “aaa” would be the same thing.
Read MoreHow To Sum All Odd Numbers In A Range
This formula will sum all the odd numbers from a given range of values. An odd number is defined as any number that has a remainder of 1 when divided by 2.
Read MoreHow To Sum All Even Numbers In A Range
This formula will sum all the even numbers from a given range of values. An even number is defined as any number that has a remainder of 0 when divided by 2.
Read MoreHow To Count All Odd Numbers In A Range
This formula will count all the odd numbers from a given range of values. An odd number is defined as any number that has a remainder of 1 when divided by 2.
Read MoreFree Book
Recent Posts

The Ultimate Guide To VLOOKUPSep 11, 2017  Functions

How To Get The Weekday Name From A DateSep 10, 2017  Formulas

How To Get The Percent Of The Month CompletedSep 6, 2017  Formulas

How To Do A Case Sensitive LookupSep 3, 2017  Formulas

How To Sum All Odd Numbers In A RangeSep 1, 2017  Formulas
Recent Tweets

RT @Sortable: Sortable ranked #12 on PROFIT 500 FastestGrowing Companies hubs.ly/H08DMh0 #PROFIT500 #WRAwesome #CDNTech #KWAweso…

Use this formula to get the first name from an email address in #Excel howtoexcel.org/formulas/howt… https://t.co/kpBxq8GlaH

14+ super cool hidden #Excel commands for your quick access toolbar. howtoexcel.org/tipsandtrick… https://t.co/Adr4h74LOf

RT @Sortable: ICYMI: We made the @DigidayAwards finalists for Best Employer. The details: hubs.ly/H08nZY60 #adtech #adops #hiring

Quick tip: Use Ctrl + B to add bold format to a cell or range in #Excel howtoexcel.org https://t.co/SG1cNjr4zv