ShareChat
click to see wallet page
search
#📰GK & करेंट अफेयर्स Students💡 #🚨UPSC Exams📚 #🙄फैक्ट्स✍ #📘परीक्षा अपडेट और तैयारी💯
📰GK & करेंट अफेयर्स Students💡 - Basic Excel Formulas S.No Formula Name Formula Pattern SUM SUM(A1:A5) (A1+A2+A3+A4+AS) SUM 2 SUM(B1,C1,D1,E1) SUM 3 PRODUCT(F1:F2) PRODUCT 4 PRODUCT(B3:B5) PRODUCT 5 PRODUCT PRODUCT(C3:C6) 6 SUBTRACTION =E3-E4 7 DIVISION 8 F3/F4 9 PERCENTAGE (63/64*100) CALCULATION 10 MAXIMUM MAX(H3:M3) MIN(H3:M3) MINIMUM 11 POWER(2,4) 12 POWER 13 AVERAGE AVERAGE(C3:C14) SQUARE ROOT SQRT(25) 14 15 COUNT COUNT(C4:P4) 16 COUNT BLANK =COUNTBLANK(C3:C16) 17 COUNTI COUNTIF(D4;Z4,"p") 18 CURRENT DATE & TIME =NOW() Basic Excel Formulas S.No Formula Name Formula Pattern SUM SUM(A1:A5) (A1+A2+A3+A4+AS) SUM 2 SUM(B1,C1,D1,E1) SUM 3 PRODUCT(F1:F2) PRODUCT 4 PRODUCT(B3:B5) PRODUCT 5 PRODUCT PRODUCT(C3:C6) 6 SUBTRACTION =E3-E4 7 DIVISION 8 F3/F4 9 PERCENTAGE (63/64*100) CALCULATION 10 MAXIMUM MAX(H3:M3) MIN(H3:M3) MINIMUM 11 POWER(2,4) 12 POWER 13 AVERAGE AVERAGE(C3:C14) SQUARE ROOT SQRT(25) 14 15 COUNT COUNT(C4:P4) 16 COUNT BLANK =COUNTBLANK(C3:C16) 17 COUNTI COUNTIF(D4;Z4,"p") 18 CURRENT DATE & TIME =NOW() - ShareChat