ShareChat
click to see wallet page
search
#basic computer #computer basic #computer basic #basic computer 🖥
basic computer - 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 - ShareChat