## SimpleANBox

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 with technology (since 1997) I …

## Limited Ceiling

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 ROUND, ROUNDUP and ROUNDDOWN, that …

## Count cells with condition – multiple conditions

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, COUNTIFS Which will count how …

## Get monthly total from table with dates

Again, thanks to one of my students, I am getting another post with example ðŸ™‚ I did promise her to post it after she sounded interesting in getting this example …

## Calculate hours between two cells

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 to help So, when A1 …

## Fx to cut long column into two columns

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 B starting from B1 to …

## Multiple Dual-Validations

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 other. Checking out sheet “Data”, …