Excel Unused Formula No.2 Min & Max

This is in continuation to our first article Excel Unused Formula No.1 Concatenate

Thanks for the amazing support, we hope that this support continues to all our future posts as well.

Today we will see how minimum function and maximum function works

Minimum Function

We come across a number of clauses in the income tax act where we need to find the minimum amount. For E.g. Gratuity, HRA, 80GG, Leave en-cashment and so on..

We will see "how to automate these calculations in excel"

Here is a snapshot of the HRA Calculation

Figure 1: HRA Caclulator

We were able to make this calculation in 2.5 miniutes, don't believe then try it out yourselves

Minimum function is very simple just type MIN and then choose the data for which you require the minimum value.

Figure 2:Minimum Formula

Maximum Function

Maximum function is the reverse of minimum function. If under any circumstance if you want to find out the maximum value then use MAX and choose the values. You should have the maximum value without much pain.

Excel Unused Formula No.1 Concatenate

Excel is really a great gift from Microsoft, but are we making use the most of it? This is one question that might strike to all of us. Forget the macros, other than the macros you have a lot of formulae which could help you do your work in a much more simpler and timely manner.

UNUSED FORMULA # 1: CONCATENATE

Figure # 1: Screenshot of the formula concatenate when entered in excel

Concatenate formula helps you to join the contents of two or more cells (max 30) in to a single cell.

We can understand how concatenate can be used through an example.

Example 

I had to enter a list of invoices raised by a company in to excel. All the invoice numbers had a prefix “April”. The invoice numbers were as follows April/1, April/2…… April/100. This is how I used concatenate to reduce my work.