Skip to main content

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

Comments

Popular Posts

Thread Consumption Chart

Code Machine name Standard Inches Needle Looper Remark T H R E D C O N S U M P T I O N S T A N D A R D Code Inch Lock Stitch Lock Stitch SNLS Single Needle Lock Stitch 3.5 52% 48%   SNLS 3.5 DNLS Double Needle Lock Stitch 8       DNLS 8 Chain Stitch Chain Stitch SNCS Single Needle Chain Stitch 12 34% 66%   SNCS 12 DNCS Double Needle Chain Stitch 22       DNCS 22 Over Lock Over Lock 3TH O/L 3 Thread Over Lock 18 15% 85%   3TH O/L 18 4TH/OL 4 Thread Over Lock 23 24% 76%   4TH/OL 23 Flat Lock Flat Lock 2TH/FL 2 Thread Flat Lock 9 34% 66%   ...

নামাযের প্রয়োজনীয় দোয়া ও তাসবীহ সমূহ

জায়নামাযে দাঁড়ানোর দোয়া اِنِّىْ وَجَّهْتُ وَجْهِىَ لِلَّذِىْ فَطَرَ السَّمٰوٰتِ وَالْاَرْضِ حَنِيْفًا وَّمَا اٰنَا مِنَ الْمُشْرِكِيْنَ- উচ্চারণ-ইন্নি ওয়াজ্জা...

Campus Memories 💝