एक्सेल में सबसे बड़ी संख्या ढूंढे Max Formula In Excel
Hello everybody , welcome to Excel made easy, , I’m your excel guru & I brought a new formula today which is called max,what does max do it finds the biggest value or the largest value within given range , I have taken example of the students names there marks in English and marks in history and the total marks , marks achieved in percentage so if you want to find out which , how what was the highest marks achieved in English so you’ll have to type in the formula, = max & then select the range here your answer ,so simple .
There is another way of doing it which is by clicking on the formula tab, insert a function, typing in the name of the formula, click on go and here comes max, click on OK & then select your range, say for example now, I’m selecting history, let us see what were the highest marks achieved in history by any given student then it will be 88 is equal to, so this is the answer, so this is your excel guru was brought this formula to you max
This training file is available for free download at my website.