excel formulas cheat sheet Archives

Nov302020 by excelhelp13No Comments

Rank Function In Excel

Maths, Statistical

Open Excel File.Select The Cell Where you Want To The Result To Get Populated.Then Add This Formula In Particular Cell =RANK(10,A1:A10)There Is Third Optional Parameter (Ascending / Descending ) =RANK(10,A1:A10, 1 'For Ascending Order') or =RANK(10,A1:A10, 0 For Descending Order)Make Sure To Lock The Range By $ Sign.Descending Order Is By Default Set Optional Parameter.That's it :)

FIND SMALLEST Number With Position In Excel

Statistical

First Select The Cell Where You Want The Result.Then Apply The Formula And Select The Array / Range And Define The Position. Once Applied It Will Check In The Array And Give You The Result By Finding The Position Of The Smallest Number.That's It :)

PERCENTAGE In Excel

FORMULAS, Maths

There is a Simple way of finding the percentage. Multiply the obtain marks , score or anything you have scored out of the total scoreboard then multiply the value into 100 and divide the sum of total scoreboard value and as a result the value found will be your percentage. For example there are 4 subject of 100 marks each so sum of total marks = 400 and assume that 1 student got 60 marks each in every 4 subject so in total he obtain 240 marks from sum of total 400 marks. So as a result the Formula will be Obtain marks * 100 / Total Marks. = 240 *100 / 400 = 60% According to math for finding percentage is to divide the numerator by the denominator then multiply the output with 100. Suppose you want to find the percentage of 50/100 then divide 50 with 100 the answer will be 1/2 the multip...