ShareChat
click to see wallet page
search
#💻కంప్యూటర్ నేర్చుకుందాం👈 #👩‍🎓GK & కరెంట్ అఫైర్స్ #👶కిడ్స్ ఎడ్యుకేషన్🎰 #🤔క్విజ్‌‌‌‌లు & పొడుపు కథలు #📖ఎడ్యుకేషన్✍
💻కంప్యూటర్ నేర్చుకుందాం👈 - Basic Excel Formulas Formula Name Formula Pattern S.No' SUM =5UM(A3:A5) =(41+42+43+44+45) SUM =(45+2+43+48) SUM =PRODUCT(F1:F2) PRODUCT PRODUCT (83*84*85) PRODUCT -(34*65) SUBTRACTIMIN IS' =([3-[4) DIVIDE =(F3/F4) PERCENTAGE (63/64*100) MAXIMUM MAX(H3:M3I 10 MINIMUM MIN(H3:M3) 11. POWER(2,4) [24 161 POWER 12 AVERAGE =AVERAGE(C3:CIA) 13.. =$0RT(25) SQUARE ROOT 14 15. COUNT =COUNT(C4:PA) COUNT BLANK FCOUNTBLANK(C3:C16) 16. COUNT IF FCOUNTIF(D4:Z4,"P") 17. CURRENT DATE & TIME NOWO 18. TODAYS DATE -TODAYO 19. DAY # OF CURRENTMONTH =DAYINOWO 20 MONTHINOWO) 21 CURRENT MONTH CURRENT YEAR YEARINOWI 2२ Basic Excel Formulas Formula Name Formula Pattern S.No' SUM =5UM(A3:A5) =(41+42+43+44+45) SUM =(45+2+43+48) SUM =PRODUCT(F1:F2) PRODUCT PRODUCT (83*84*85) PRODUCT -(34*65) SUBTRACTIMIN IS' =([3-[4) DIVIDE =(F3/F4) PERCENTAGE (63/64*100) MAXIMUM MAX(H3:M3I 10 MINIMUM MIN(H3:M3) 11. POWER(2,4) [24 161 POWER 12 AVERAGE =AVERAGE(C3:CIA) 13.. =$0RT(25) SQUARE ROOT 14 15. COUNT =COUNT(C4:PA) COUNT BLANK FCOUNTBLANK(C3:C16) 16. COUNT IF FCOUNTIF(D4:Z4,"P") 17. CURRENT DATE & TIME NOWO 18. TODAYS DATE -TODAYO 19. DAY # OF CURRENTMONTH =DAYINOWO 20 MONTHINOWO) 21 CURRENT MONTH CURRENT YEAR YEARINOWI 2२ - ShareChat