Tag Archives: MIN

Determine leap year with #Excel

Posted on February 29, 2020 by

Today is a special day.  Today is February 29th, which happens only once every four years.  And today is Saturday, when I usually post a new blog.  So let’s talk about how to determine if a year is leap year using … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , , | Leave a comment

Using MIN/MAX to answer whichever lower/higher questions

Posted on August 16, 2017 by

What is “Whichever higher”? Situation: You call to your favourite restaurant to reserve a private room for family dinner on Saturday.  The restaurant manager tells you that there will be a minimum charge of $2000 for a private room.   That mean, … Continue reading →

Rate this:

Posted in Formula | Tagged , , | Leave a comment

How to calculate number of overlapping days for two periods?

Posted on October 25, 2014 by

Have you ever encountered a situation that you need to find out how many days in Period 2 fall into Period 1? Is using IF(IF…(IF…(IF…(IF….. the first thing in your mind?

Rate this:

Posted in Formula | Tagged , , | 10 Comments

How Excel formula can save your time?

Posted on September 6, 2014 by

Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example.  I was … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | 4 Comments