Excel Formula

 Excel Formula

Upper This option is used to display the text in the capital letter.

1Method =UPPER(CELL ADDRESS) ENTER

2Method =UPPER(“NAME”) ENTER

Lower This option is used to display the text in the small letter.

1Method =LOWER(CELL ADDRESS) ENTER

2Method =LOWER(“NAME”) ENTER

Count It is used to count the cell where display digits in the given

range.

Step =COUNT(START CELL ADDRESS: END CELL ADDRESS)

ENTER

Count Blank It is used to count the blank (empty cell) cell in the given

range.

Step =COUNTBLANK(START CELL ADDRESS: END CELL ADDRESS) ENTER

Count A It is used to count the cell that is not empty in given range.

Step =COUNTA(START CELL ADDRESS: END CELL ADDRESS) ENTER

Now It is used to display today ‘s current date and time of the of the

computer.

Step =NOW() ENTER

Today It is used to display the current today ‘s date of the computer.

Step =TODAY()ENTER

Roman It is used to display the Roman value of the given digits.

Step =ROMAN(DIGIT) ENTER

Square It is used to display the square value of the given digits.

Step =SQRT(DIGIT) ENTER

Power It is used to display the value of the given digits.

Step =POWER(NUMBER,POWER) ENTER

Addition/Sum This option is used to display the sum value of the given

digit.

Step =SUM(START CELL ADDRESS : END CELL ADDRESS) ENTER

Average

This option is used to display the Average value of the given digit.

Step =AVERAGE(START CELL ADDRESS : END CELL ADDRESS) ENTER

=NUMBER OF TOTAL MARKS/ NUMBER OF TOTAL SUBJECT

RESULT This function is used to display the result according to Obtained

Marks.

=IF(AND(D3>29,E3>29,F3>29,G3>29,H3>29),"PASS","FAIL")

Division

Marks Wise This function is used to display the division according to

Obtained Marks.

=IF(F2>=300,"FIRST",IF(F2>=225,"SECOND",IF(F2>=150,"THIRD"

,"FAIL"))) ENTER

 Note F2 is cell Address Where total marks (Total Obtained Marks)

is display in data.

Subject Wise This function is used to display the division according to

Obtained Marks as well as all Subject Marks.

=If(AND(F2>=300,A2>=30,B2>=30,C2>=30,D2>=30,E2>=30,F2

>=30),"First",If(AND(F2>=225,A2>=30,B2>=30,C2>=30,D2>=30

,E2>=30,F2>=30),"Second",If(AND(F2>=150,A2>=30,B2>=30,C2

>=30,D2>=30,E2>=30,F2>=30),"Third","Fail"))) Enter

 Note F2 is cell Address Where total marks(Total Obtained Marks )

is display & A2,B2,C2,D2,E2 & F2 is a cell address where subject marks

is display in data.

DEVISION According to result and average

=IF(AND(K3="PASS",J3>=60),"1st",IF(AND(K3="PASS",J3>=45),"2nd",IF(

AND(K3="PASS",J3>=30),"3rd","FAIL")))

Grade This option is used to display the Grade according to Condition.

=IF(F2>=95,"A+",IF(F2>=85,"A",IF(F2>=80,"B+",IF(F2>=75,"B",IF(F2>

=70,"C+",IF(F2>=65,"C",IF(F2>=50,"D","E"))))))) Enter

 Note F2 is Cell Address where Percentage is display in data.

Remarks This option is used to display the Remarks according to

Condition.

=IF(F2>=90,"EXCELLENT",IF(F2>=80,"VERYGOOD",IF(F2>=70,"GOOD",

IF(F2>=60,"PASS",IF(F2>=50,"WORKHARD",IF(F2>=40,"PROMOTE","F

AIL"))))))

Note F2 is Cell Address where Percentage is display in data Review Tab