1 / 10

Excel Formulas in hindi

This is pdf of Excel Formulas in hindi

pramod140
Download Presentation

Excel Formulas in hindi

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web-http://www.computerexpertlinkinhindi.com/ Subscribe on youtub- https://www.youtube.com/channel/UC0n5P5W9HRLXeumlg8RN2cA/videos Link on fb- https://www.facebook.com/Computer-expert-link-4you-1625905290758770/ Follow on Twitter-https://twitter.com/pramodmahor786 Excel Basic Formulas in Hindi 1. Formula Sum :- Sum Formula Use Excel Sheet Put TOTALDisplay Digit Exp. = Syntax : sum(First Cell Digit:Second Cell Digit) Enter =sum(A1:A2) Enter

  2. 2.Formula (-) :- Use Excel Sheet Put Digit (-) Exp. = Syntax : (First Cell Digit-Second Cell Digit) Enter = (A1-A2) Enter 3.Formula Max:- Max Formula Use Excel Sheet Put Digit Digit Display Exp. = Syntax : Max(First Cell Digit:Last Cell Digit) Enter =Max(A1:A5) Enter 4.Formula Min:- Min Formula Use Excel Sheet Put Digit Digit Display Exp = Syntax Min(First Cell Digit:Last Cell Digit) Enter =Min(A1:A5) Enter 5.Formula Abs:- Abs Formula Use Excel Sheet Put Nigative (-) Digit Positive Digit Change Exp = Syntax Abs(First Cell) Enter (

  3. =Abs(-A1) Enter 6.Formula Power:- Power Formula Use Excel Sheet Put 3 Digit (Power, 3 ) Exp = Syntax Power(First Cell Digit, Second Cell Digit) Enter = Power (A1,A2) Enter 7.Formula Product:- Product Formula Use Excel Sheet Multipli ( Digit Put Exp = Syntax Product (First Cell Digit*Second Cell Digit) Enter =Product (A1*A2) Enter 8.Formula Divide:- Divide Formula Use Excel Sheet Put Divide ( Digit Exp = Syntax Product(First Cell Digit/Second Cell Digit) Enter =Product (A1/A2) Enter 9.Formula Sqrt:- Sqrt Formula Use Excel Sheet Put Digit (√ ) Exp

  4. = Syntax Sqrt (First Cell Digit) Enter =Sqrt (A1) Enter 10.Formula Average:- Average Formula Use Excel Sheet Average Digit Put Exp = Syntax Average (First Cell Digit:Last Cell Digit) Enter =Average (A1:A2:A3) Enter 11.Formula Now:- Now Formula Use Excel Sheet Current Date & Time Put Exp Syntax =Now () Enter 12.Formula Today:- Today Formula Use Excel Sheet Current Date Put Exp Syntax =Today () Enter 13.Formula Count:- Count Formula Use Excel Sheet Put Digit (Count) Exp Syntax =Count (First Cell Digit: Last Cell Digit) Enter

  5. =Count (A1: A9) Enter 14.Formula Upper:- Upper Formula Use Excel Sheet Small Text Capital Type Exp Syntax =Upper(First Cell Type ‘Text’) Enter =Upper(A1) Enter 15.Formula Lower:- Upper Formula Use Excel Sheet Capital Text Small Type Exp Syntax =Lower(First Cell Type ‘Text’) Enter =Lower(A1) Enter 16.Formula proper- ProperFormula Use Excel Sheet Put Small Capital Text Proper Sentence Word Capital Small (Computer). Exp Syntax =Proper(First Cell Type ‘Text’) Enter = Proper (A1) Enter

  6. 17.Formula Date Difference:- Excel Sheet Date Difference Cell Date Date Put Foumula Use Exp Syntax =Datedif(First Cell Date,Second Cell Date”d”) Enter =Datedif (A1,A2, ”d”) Enter 18.Formula Month Difference:- Excel Sheet Month Difference Cell Date Date Put Foumula Use Exp Syntax =Datedif(First Cell Date,Second Cell Date”m”) Enter =Datedif (A1,A2,”m”) Enter 19.Formula Year Difference:- Excel Sheet Year Difference Cell Date Date Put Foumula Use Exp Syntax =Datedif(First Cell Date,Second Cell Date,”y”) Enter =Datedif (A1,A2,”y”) Enter 20.Formula Weeknum:- Excel Sheet Weekly Foumula Use

  7. Exp Syntax =Weeknum(First Cell Date,) Enter =Weeknum (A1) Enter 21.Formula Days360:- Excel Sheet First Date & Last Date Day Count Foumula Use Exp Syntax =Days360(First Cell Date, Second Cell Date) Enter =Days360 (A1, A2) Enter 22.Formula Roman:- Roman Formula Use Excel Sheet Text Digit Roman Put Exp =Roman(First Cell Type ‘Text’) Enter =Roman(A1) Enter 23.Formula Log:- Log Formula Use Excel Sheet Put Digit Log Exp Syntax =Log (First Cell Digit) Enter

  8. =Log(A1) Enter 24.Formula MMULT:- MMULT Formula Use Excel Sheet Digit Matric Answer Put Exp Syntax =Mmult (First Row Digit, Second Column Digit) Enter =Mmult(A1,A2) Enter 25.Formula Mode:- Mode Formula Use Excel Sheet Put Digit Digit Display Digit Excel Sheet Put Exp Syntax =Mode(First Cell Digit:Last Cell Digit) Enter =Mode(A1:A3) Enter 26.Formula Len:- Len Formula Use Excel Sheet Put Text Count Exp Syntax =Len(First Cell Text) Enter =Len(A1) Enter

  9. 27.Trim Formula –Trim Formula Use Excel Sheet Particular Cell Put Text Spacing Excel Sheet Data Put Text Spacing Trim Formula Use Particular Text Spacing Note- “Trim Formula use” “Len” Formula “len formaul” Text Counting Text Spacing Count Exp Syntax =TRIM(First cell Text) =TRIM(D9) 28.Formula Simple Interest:- Simple Interest Formula Use Digit Simple Interest Excel Sheet Put Exp Syntax = (Principal* Rate*Time/100) Enter =1000*5%*3 Year/100 29.Formula Countifs- Countifs Formula Use Excel Sheet Column Put Category Excel Sheet Column Category Type Place Post Company

  10. Particular Place Post Countifs Formula Use Exp Syntax= Countifs(First Category Cell Digit:,Place,Second Category Cell Digit,Post) =COUNTIFS(D7:D12,G7,E7:E12,H7) 30.DateValue Formula=DateValue formula Use Excel Sheet Put Simple Text Date Formula Exp Syntax =Datevalue(Datetext) Enter =Datevalue(1/4/1998) 31.Countblank Formula- Countblank formula Use Excel Sheet Put Data Blank cell Count Exp = Countblank (First cell:Last cell) Enter Syntax =COUNTBLANK(C1:C12) dEI;wVj dh fgUnh esa T;knk tkudkjh ds fy, Website ij vk;s Click- http://www.computerexpertlinkinhindi.com/

More Related