Important Formulas


=SUM(C1:H1)

=MAX(C1:H1)

=MIN(C1:H1)

=COUNT(C1:H1)

=AVERAGE(C1:H1)

=ROUND((A1*0.50),0)

=AVERAGE(C1:H1)

=A1+B1+C1

=A1/6

=A1-H1

=A1*B1

=(A1+B1)*0.50

 

=RANK(C5,$C$5:$C$10,0)àDescending

=RANK(C5,$C$5:$C$10,1)àAscending

=IF(C1>=40,”PASS”,”FAIL”)

=IF(MIN(C1:H1)>=40,”PASS”,”FAIL”)

=COUNTIF(C1:H1,”>50”)

=COUNTIF(C1:H1,”male”)

=VLOOKUP(K1,A1:K10,4,0)

=SUMIF(A1:C12,B15,C1:C12)

 


Comments

Post a Comment

Popular posts from this blog

Use Of Round Formula

Image
  =Round (number, num_digit) Ex....  =Round(d5,1)   =Roundup(d5,1) =Rounddown(d5,1) Number Digit Round Roundup Round Down 12345.6789 1 12345.7 12345.7 12345.6 12345.6789 2 12345.68 12345.68 12345.67 12345.6789 3 12345.679 12345.679 12345.678 12345.6789 4 12345.6789 12345.6789 12345.6789 12345.6789 0 12346 12346 12345 12345.6789 -1 12350 12350 12340 12345.6789 -2 12300 12400 12300 12345.6789 -3 12000 13000 12000 12345.6789 -4 10000 20000 10000
Read more

Use Of COUNTIF Formula (Countif formula-ன் பயன்பாடு)

Image
  COUNTIF             Countif formula-ஐ பயன்படுத்தி நாம் குறிப்பிட்ட எண்ணையோ அல்லது வாா்த்தையையோ எண்ணி பாா்க்கும் முறை CRITERIA FORMULA EXAMPLE DESCRIPTION Count if  greater than =COUNTIF(A2:A10,">5") Count cells where value is greater than 5. Count if  less than =COUNTIF(A2:A10,"<5") Count cells with values less than 5. Count if equal to =COUNTIF(A2:A10,"=5") Count cells where value is equal to 5. Count if greater than or equal to =COUNTIF(C2:C8,">=5") Count cells where value is greater than or equal to 5. Count if less than or equal to =COUNTIF(C2:C8,"<=5") Count cells where value is less than or equal to 5. Count if  Text =COUNTIF(C2:C8,”male”) Count cells where value is equal to male  
Read more