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.