![Basic Excel Formulas S.No Formula Name Formula Pattern SUM SUM(A1:A5) SUM (41+42+43+44+45) 2 SUM (45+2+43+48) 3 =PRODUCT(F1:F2) PRODUCT 4 PRODUCT (83*84*85) 5 PRODUCT (34*65) 6 SUBTRACTIMIN IS (E3-E4) 7 DIVIDE (F3/F4) 8 PERCENTAGE (G3/64*100) 9 MAXIMUM MAX(H3.M3) 10 =MIN(H3:M3) MINIMUM 11 =POWER(2,4) [24=16] POWER 12 AVERAGE =AVERAGE(C3:C14) 13 SQUARE ROOT =SQRT(25) 14 15 COUNT =COUNT(C4:P4) 16 COUNT BLANK =COUNTBLANK(C3:C16) =COUNTIF(D4:Z4,"P") COUNT IF 17 =NOW() 18 CURRENT DATE & TIME ETODAYO TODAYS DATE 19 =DAY(NOW()) DAY # OF CURRENT MONTH २० CURRENT MONTH =MONTH(NOW()) 21 CURRENT YEAR =YEAR(NOW() 22 Basic Excel Formulas S.No Formula Name Formula Pattern SUM SUM(A1:A5) SUM (41+42+43+44+45) 2 SUM (45+2+43+48) 3 =PRODUCT(F1:F2) PRODUCT 4 PRODUCT (83*84*85) 5 PRODUCT (34*65) 6 SUBTRACTIMIN IS (E3-E4) 7 DIVIDE (F3/F4) 8 PERCENTAGE (G3/64*100) 9 MAXIMUM MAX(H3.M3) 10 =MIN(H3:M3) MINIMUM 11 =POWER(2,4) [24=16] POWER 12 AVERAGE =AVERAGE(C3:C14) 13 SQUARE ROOT =SQRT(25) 14 15 COUNT =COUNT(C4:P4) 16 COUNT BLANK =COUNTBLANK(C3:C16) =COUNTIF(D4:Z4,"P") COUNT IF 17 =NOW() 18 CURRENT DATE & TIME ETODAYO TODAYS DATE 19 =DAY(NOW()) DAY # OF CURRENT MONTH २० CURRENT MONTH =MONTH(NOW()) 21 CURRENT YEAR =YEAR(NOW() 22](https://cdn-img.sharechat.com/bd5223f_s1w/compressedcompressed_gm_40_img_268025_280efac_1774976266564_sc.webp?tenant=sc&referrer=pwa-sharechat-v2&f=64_sc.webp&w=360)
More like this
janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 47- janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 1011
- janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 179
- janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 147
- janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 65
- janani Prabakaran#computer basic #computer basic #basic computer 🖥 #basic computer 1011
- janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 126
- janani Prabakaran#basic computer #computer basic #computer basic #basic computer 🖥 169