Skip to main content

Posts

Showing posts from February, 2019

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")))))))))