Exel Spreadsheet ☑ Formula

1. Address => =Collum x Raw

2. Addition(+) => =Sum(A1:B1)

3. Substruction(-) => =Sum(A1-B1)

4. Multipliction(x) => =Sum(A1*B1)

5. Division(/) => =Sum(A1/B1)

6. Percentage(%) => =Sum(A1/B1*100)

7. Mark Sheet =>
=IF(A1>=160,"4.00",IF(A1>=150,"3.75",
IF(A1>=140,"3.50",IF(A1>=130,"3.25",
IF(A1>=120,"3.00",IF(A1>=110,"2.75",
IF(A1>=100,"2.50",IF(A1>=90,"2.25",
IF(A1>=80,"2.00","00")))

8. Grading System =>
=IF(A1>=160,"A+",IF(A1>=150,"A",IF(A1>=140,"A-",
IF(A1>=130,"B+",IF(A1>=120,"B",IF(A1>=110,"B-",
IF(A1>=100,"C+",IF(A1>=90,"C",
IF(A1>=80,"D","F")))))))))