Category: Math and Trig

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...

The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round  number to any value up Unlike...

We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function,...

Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded...

We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others...

Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column...

It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each...