Excel 🖥Round, RoundUp, RoundDown, Mround Formula in Hindi

✔️ Join Pandrive Computer Course - offline.pcskil...
इस वीडीयो में Excel के बहुत महत्‍वपूर्ण Function Round, RoundUp, RoundDown, Mround Formula के बारे में जानकारी दी है Round के ये सभी Formula आपके बहुत काम आयेगें आशा है ये वीडीयो आपका पंसद आयेगा
हमारे टॉप 5 वीडीयो -
1- केवल Hindi Typing वाले देखें - goo.gl/fKXmvw
2- Excel में IF को नहीं सीखा तो क्या सीखा ? - goo.gl/yPh5vb
3- Excel Expert बनना है तो ये देखो - goo.gl/2W66t4
4- Excel का ये Formula अापकी सारी थकान मिटा देगा - goo.gl/LEWFgL
5- क्‍या आपने Excel में मैक्रो (macro) सीखा ? - goo.gl/k2HQcm
एक्सेल के सभी वीडीयो यहॉ देखें - goo.gl/aF43Hs
एक्सेस के सभी वीडीयो यहॉ देखें - goo.gl/LRohxH
वर्ड के सभी वीडीयो यहॉ देखें - goo.gl/1yKpk1
कंप्यूटर नेटवर्किंग के सभी वीडीयो यहॉ देखें - goo.gl/9qmhvL
फोटोशॉप के सभी वीडीयो यहॉ देखें - goo.gl/AVsjLZ
विंडोज 7 के सभी वीडीयो यहॉ देखें - goo.gl/z44h2d
जीमेल के सभी वीडीयो यहॉ देखें - goo.gl/h3EZzv
यूट्यूब के सभी वीडीयो यहॉ देखें - goo.gl/zqzoJW
टेक्नोलॉजी के सभी वीडीयो यहॉ देखें - goo.gl/pfQKsk
Facebook - / geekyabhimanyu
WebSite - mybigguide.com
Like us on Facebook : / mybigguide
Follow us on Twitter : / mybigguide
Android app on Play store : goo.gl/pNJWTv
हर रोज नया वीडियो ट्यूटोरियल हिन्‍दी में पाने के लिये हमारा यूट्यूब चैनल सबस्‍क्राइब करें और घर बैठे ही जॉइन करें माय बिग गाइड स्‍मार्ट क्‍लास 👈
इसके अलावा अगर आप हिंदी में और भी तकनीकी जानकारी प्राप्‍त करना चाहते हैं तो आप हमारी बेवसाइट mybigguide.com पर जा सकते हैं और अगर आपको कुछ पूछना है तो आप हमें [e-mail] पर मेल कर सकते हैै

[@rajgupta4298]

आप महान हो ज्ञान का सागर हो आपकी वजह से बहुत कुछ सिखेते है

[@kailash.samariya]

sir excel me aisa kuch set kr sakte he kya jese 100.49 me 49 paise hoto 100 rah jaye or 100.51 he to 101.00 ho jaye tally me normal rounding ki tarah

[@vjybarnwal]

बहुत ही अच्छा... roundup & rounddown का फर्क आज पता चला

[@anjaneyulukodam9961]

Thanks for your kind explanation of the round formula. Heartily congratulations for the great festival of Bathukamma, Dussehra. Kodam Anjaneyulu Sircilla TS

[@saddamhossen1659]

Kahi din se is muskil ka samna karna para jo up se solutions ho geya Dil se thanks

[@mahendrasaparihar7792]

very very nice sir mujhe aapse bahut sara knowledge sikhne ko milta hai

[@vgdeshmukh74]

Sir, Awesome tutorial.

[@ddsanskritam3743]

बहुत अच्छा है। पर एक सवाल है। उदाहरण के लिए अगर10.3 है तो 10 हो जाए और और.... 10.6 हो तो 11 हो जाए दोनो कंडीशन एक साथ एक ही कॉलम में काम करे। up down कोई ऐसा फार्मूला हो और बता सकते हो तो जरूर बताना। धन्यवाद।

[@sandipdongare9310]

Useful.... Formulas in accounting working

[@shivkumarbatham7360]

Aaj pura clear ho gaya👍👍👍👍

[@shivkumarbatham7360]

Aaj samajh Aa gaya, bahut din se book se sajhne ki koshish kar raha tha par samajh nahin Aa raha tha

[@RahulJauhari]

Very useful formula thanks sir

[@mahendrakumarbagria4725]

good really truthful thanks

[@anjaneyulukodam9961]

Good night sir, Wish you and all your family members a very happy Dussehra !! Kodam Anjaneyulu Sircilla

[@prabhakarpawar573]

very usefull video sirji

[@vishalkumarverma7321]

Awesome sir 👍👍👍👍👍

[@sachinranjanrout9284]

Help full video

[@rajualiwal1051]

Good video Sir

[@girishtax]

Sir, one suggestion kindly provide excel sheet of your video to your followers. It is help full to them. Thanks.

[@alihasanreshamwala]

Very useful video

[@prakashmaikhuri]

Very nice

[@dhansayyadav7085]

आदरणीय महोदय राउंड के विषय में आपकी जानकारी अच्छी लगी मेरी समस्या है कि जैसे कोई संख्या 650 या ज्यादा 651 या 652 या ज्यादा को राउंड करे तो 700 हो जाए किन्तु जैसे ही 650 से कम हो तो 600 में राउंड हो जाय जैसे 649 या 648 या कम 600 में राउंड हो जाय इसके लिए फार्मूला बताने का कष्ट करे

[@SB-cz3ww]

use if formula

[@Kartoon0786]

Very nice sir g

[@zameerahmad]

Sir 0.50 paisa agar aye to show ho baki normal round ho jaye esa formula batao

[@manishjha2130]

helpful video

[@विकासकुमार-ढ6प]

अभिमन्यु भईया नमस्कार मैं विकास कुमार एक विद्यार्थी हूॅं और काफी समय से आपके चैनल से लाभ ले रहा हूॅं मैं पहले भी काफी चैनल से जुड़ा हूॅं लेकिन माई बिग गाइड से मैंने इतना कुछ सीखा है जिसका आप अंदाजा भी नही लगा सकते लेकिन मैं अब चाहता हॅंू कि आप कोरल ड्रा पर भी विडियों बनाना स्टार्ट करें विकास कुमार गढ़मुक्तेश्वर जिला हापुड़ (उ0प्र0)

[@yuniskhan1471]

Sir ji koii simple invoice bill ke upr b ek video kar dijiye uske undar SGST CGST dono ho

[@malekarif381]

THANKS ...

[@bharat4891]

Nice Sir

[@Abhi_Thefitbanker]

Sir.. Good evening... Mai aapka sabhi video dekhta hun... apne friend k sath share bhi krta hun... sir please mujhe Filter box k bare m bataye.... Jaise kisi sheet m koi word search krna ho search kiya hua word highlight ho jaye aur sath hi us word ka row filter krna ho.. to kaise krenge.. please is bare m video banaye...

[@ravidas4880]

Nice video

[@ishwarrana9025]

Thank u brother

[@gurmailsingh7396]

Thanks sir

[@Alexbilwal__13456]

sir jee mp ke vyapam or cpct ke exam me word or excel home insert pagelayout formula data reveiw view ke sabhi point jese home page me jitne bindu hote he unka use kese hota he un sabhi ek complit video bnaya

[@mybigguidehindi]

कुछ वीडीयो बनाये जा चुके हैं देखें और बतायें - एक्सेल के सभी वीडीयो यहॉ देखें - goo.gl/aF43Hs एक्सेस के सभी वीडीयो यहॉ देखें - goo.gl/LRohxH वर्ड के सभी वीडीयो यहॉ देखें - goo.gl/1yKpk1 कंप्यूटर नेटवर्किंग के सभी वीडीयो यहॉ देखें - goo.gl/9qmhvL फोटोशॉप के सभी वीडीयो यहॉ देखें - goo.gl/AVsjLZ विंडोज 7 के सभी वीडीयो यहॉ देखें - goo.gl/z44h2d जीमेल के सभी वीडीयो यहॉ देखें - goo.gl/h3EZzv यूट्यूब के सभी वीडीयो यहॉ देखें - goo.gl/zqzoJW टेक्नोलॉजी के सभी वीडीयो यहॉ देखें - goo.gl/pfQKsk

[@chipstead7919]

sir kindly show the full page, don't zoom on particular cell coz when u focus only on a particular cell and whatever u r selecting on other side can't be seen by us and creates difficulty to understand.

[@rshansharma2167]

Bhai Photoshop pr bhi video bnao na Pls

[@arjungupta0811]

Sir can you make video of slope and intercept function

[@sanjayagre7483]

Thank

[@sonujatav291]

Thank you sir

[@vipinrokers9699]

Thnks sir ji

[@kodairoadkannan]

super

[@PARVAIZ95]

good sir

[@entiredworld255]

sir mujhe goto special wali video chahiye....please sir

[@flowfittingequipment6828]

thanks sir, ek mujhe round ka formula chahiye jaise ki 1505.40 ho round ka kalam me desimal ke bad ke round batae yani ki - 0.4 aur yadi 1505.60 ho to round me 0.4 ho to ans 1506 ho jayega

[@omkaryadav5098]

Sir corel draw ke bare me full proces video banao

[@kpnalshj]

Bhai ko ram ram .... Bhai sab mra bhi ek question hal kr do yr...

[@ABHIJITKARMAKARrkmania]

A big thanks for you.....

[@rakeshkanojia5362]

how to round up in 50 paise in round 10 example 360.50 in 370 or 360.33 in 360

[@shashikantvakte8988]

👌

[@hasmukhlalsharma7625]

please sir is topic pr video banaiye jaise ki 7*8=56 to ab 56 ko change nhi karna chahte bhale he 7*8 ko delete kr dene ke baad bhi 56 ka 56 hi rhe

[@pradeepvishwakarma4861]

Sir excel me ek yesa video banao kisi bhi number par click kare image show ho jaye plz sir

[@PARVAIZ95]

sir word me watermark use karne ke liye printer me kya setting karni padti hai

[@rajgupta4298]

Sir total value column ko kasai round of kare pls bataye

[@manx1596]

kya excel templet ka data kisi aur sheet me aa sakta hai, jaise koi maoney reciept excel templet me banay aour uska data dusre sheet me store hota jaye

[@udaynarayanshukla2190]

10 के ,गुणक मे या 100 के गुणक मे Excel द्वारा % निकालना बताए ।जैसे {87987 का 11% =9678.57} परन्तु चाहिए 9680 या 9700

[@viralsoni3612]

Sir ek help Karo pls. Koi ek date ko 2 month or koi week k bad me kon so date aati he ???? Eske regarding video upload karoge pls?

[@shivkumarbatham7360]

Round function

[@RajeshKumar-uq4lb]

Sir wamis software me work karne ke bare me jankari de sakte ?

[@EPariksha]

Sir mangal inscript and devnagri font me kya difference hai

[@eswarsinghlahorakar314]

Sir regional language me 12 months mera PC me add karna hai who ?

[@rakeshkanojia5362]

how to roundup in 360.3 in 360 or 361.33 in 361.33 in 370

[@Hindu_Bhai501]

Sir agar mujhe kisi ek cell ka perticular figure total amount main se minus karke dikhana hai to kaise karen?

[@sridkssri]

सर जी मैंने एक्सेल में एक टेबल बनाई है इसमें जब भी डाटा फ़िल्टर करते है तो टोटल और सीरियल नंबर बिगड़ जाता है। हमने आपका एक विडिओ देख कर एक बार बनाया था मुझे अब वो फार्मूला याद नहीं है और मै विडियो भी खोज नहीं पा रहा हूँ कृपया हमे गाइड करे

[@VijayKumar-ml6xv]

hello sir namaskar ! mujhe ek trick pata karni hai yadi excel sheet ki do cell me normal value di ho 13 - 18 aur 11 - 16 agar isko ek cell me compare karene par hum chahte hai yah value 11 or 13 se kam ho tab bhi automatic bold ho jaye aur 16 or 18 se jyada ho tab bhi automatic bold ho jaye toh kya aisa ho sakta hai ? please bataye sir !

[@satyanarayanprajapat3852]

Excel me vlookup formula se inglish to Hindi translet karna hai

[@manojkashyap-ye3kw]

PLEASE SIR UPLOAD THE VIDEO OF ENGINEERING FUNCTION IN EXCEL

[@ayubpatel8910]

Isme 3rd decimal ko ya 0 or 5 show karna h like 100.015, 100.010, 100.215,100.210 Plz reply

[@amitkumarsingh331]

॥ नमस्कार सर ॥ excel मे कॉलम के top पर जो हेडिंग डलते है नीचे डाटा fill करते हैं Scroll कर के नीचे जाने के बाद हेडिंग hide हो जाता है जिससे डाटा feed करने में कठिनाई होती है, फिर ऊपर जाओ हेडिंग देखो फिर डाटा feed करो । ऐसा कोई ट्रिक हो जिसमे हेडिंग का Row (Top Row) scroll करने के बाद भी hide नही हो, तो इस सम्बन्ध में मार्गदर्शन देने की कृपा की जाय । धन्यवाद

[@SB-cz3ww]

first top Row ko freeze karia

[@SB-cz3ww]

First top Row ko freez karia

[@dilipmishra6881]

Freeze panes option pe jakar kar le

[@manojjaiswal4086]

Sir Nearest to Round 10 karna ho to

[@missyouve8136]

Sir.... aths typint start karo na

[@bhurewalacentre8434]

HOW TO USE UPPER OR LOWER FUNCTION IN VALIDATION

[@nancysharma605]

Agar 4,5,6,7,8,9 value dalte h to value same aati h Aisa kyu

[@puneetvij8433]

Abhimanyu Sir, और बढ़िया से explain कर सकते थे आप इसको | : (

[@RomanticIndia]

Hello sir ap se request hai ki ap ek KZbin Chanel banane ka video late sir please seriously comment kar rahi hoon 20 February ke bad se Jo KZbin policy ai hai uske bad KZbin Chanel create new video banal sri created by step by step full video create KZbin channel please please please please please please please you 😢😢

[@jahidali1052]

Agar isi aKade ko 10 ki jagah 5 kaise lu exp. Jaise ki ,= 1233 ko 1235 me kaise lu

[@impressionglass1548]

brother ans Mila kya apko?

[@Gb_musical]

Apka video plylist me. Nehi he.esliya apk video dekne me thora dikat hoti he.vag vag krke plylist me dena sahiye sir

[@Pitter5775]

Hi Sir can u help me how to get values of a particular cell & it will change automatically on daily wise which will count as a FTD.P LZ HELLP ME

[@nancysharma605]

Last m 9 digit likhe to same value aati h Aisa kyu ,1,2,3 value likhte h to digits change Hoti h

[@santhanamrajagopal2662]

Sir, Total sale assessable value is 12154/- which was included by taxable rate 5%,12%,18% goods, And tax amount Rs. 6012/- now how i find 5% goods,12% goods like,18,28% good value from Rs.12154/- tax must be Rs. 6012/- Pls. Help

[@dilshadali1221]

sir mround me kaise pata kare ki 10327me 2 ka bhag karne ke liye formula lagakar 10328 hi aayega 10326 kyun nahi jabki ye bhi 2 se divide ho raha he aur 10327 me 5 se bhag karne par 10325 kyun aaya aur 10320 ya 10335 kyun nahi please give me reply please

[@chetuchaudhari2435]

How can i convert to number into word in gujrati

[@FreeFire-uk5fi]

Sir aapne round ko aap saji see nahi Bata rahe hai

[@Alexbilwal__13456]

सीपीसीटी के पेपर होता है जिसमें 52 नम्‍बर का कंप्‍यूटर का जीके होता है उसमें सिलेबस के अनुसार विडियों बनाये तो मध्‍यप्रदेश के लाखो टाईपीस्‍टों का भला हो जायेगा । सर जी में आपको सीपीसीटी एग्‍जाम का सिलेबस को मेल कर रहा हूं।

[@ShrawanKumar-jw7vm]

Abhimanyu sir naya wala chasma apki face size ke hisab se thora chhoota hai ,

[@bharatchaurasiya4561]

Ni

[@harish23537]

10 के पूर्णाक में answer आये इसके लिए क्या करना पड़ेगा जैसे कि 103 आया तो 110 चहिय ans में

[@k2shorts382]

=Roundup(cell select of 103, - 1)

[@hafizansar7683]

Sir mujhe ak F. Bta do jo ki manlo 15000000 Amt. Hai or mai chahta hu ki ye amt ki jagah 1.5 aaye aysa koi kuchha aap batao sir

[@yogisharma07]

Hafiz Ansar 1 crore se devide kr de

[@healthiswealth1791]

zero q lagaya ni bataya

[@rajatkander6191]

i do not understand Mround function.

[@PANJPSARDA]

मेरे को एक प्रोब्लम ह। एक्सेल में जीएसटी इनवॉइस में आईजीएसटी सीजीएसटी ओर एसजीएसटी में if फॉर्मूला set किया हुआ ह जिस का लिंक जीएसटी नंबर से दिया हुआ ह स्टेट टैक्स ओर सेंट्रल टैक्स का लेकिन इस में राउडिंग फॉर्मूला काम नहीं करता ह error बताता ह में क्या करू PANKAJ SARDA surat Gujarat 9016494647

[@surendermehra3452]

sir aap ki email id kya hai

[@mybigguidehindi]

[e-mail]

[@Alexbilwal__13456]

Detailed Syllabus for CPCT Sr No Competency and Sub Topics 1.0 Familiarity with computer systems 1.1 Awareness about different aspects regarding computer hardware such as generations and types of computers, printers, input and output devices and hardware components such as Central Processing Unit (CPU) like arithmetic logic unit, control unit, memory unit; Universal Serial Bus (USB), Liquid Crystal Display (LCD), Motherboard, Sound Card, Graphics Card, and related concepts; Input Devices such keyboard, mouse, light pen, touch screens, graphics tablets, joystick, Microphone, Optical Character Reader, MICR, Scanner, digital or web camera, card reader, barcode reader, biometric sensor; Output Devices such as Monitor or visual display unit, printer (impact or non-impact), speaker, plotter; and Secondary Storage Devices such as USB Pen Drives, floppy disks, Compact Disk (CD), Digital Video Disk (DVD), Blue Ray Disk, Solid State Drive etc.; 1.2 Awareness regarding different aspects about computer software including software categories such as System Software, Application Software, Embedded Software, Proprietary Software, Open Source Software; Computer Languages such as Machine Level Language, Assembly Level Language, High Level Language, Interpreter, Compiler; Operating Systems such as Windows and Linux etc. and concepts of Memory Units such as Bit, Byte, Megabyte, Gigabyte, Terabyte etc. 2.0 Knowledge of Basic Computer Operations 2.1 Awareness of generic steps required for setting up a computer, booting and shutting down, logging on and off to a network, determining an IP address, verifying physical connectivity to a network, installing and updating software packages, disabling applications from running on start-up, uninstalling a software from computer, customising desktop background, resizing windows, volume controls of computer, setting up a new printer or webcam or scanner or other peripheral devices, understanding of steps to protect computers from power disturbances and basic troubleshooting including power backups. 2.2 Awareness of System Administration and Security concepts such as setting options and preferences in an Operating System; encryption of data; keeping personal data private and secure; creating strong passwords; changing passwords; checking a system for bugs, spyware or other malicious application through virus scanners; 2.3 Awareness of concepts and processes related to file management functions such as copying files to memory disk, undoing mistakes, using default help modules, connecting to the Internet and downloading and uploading files, setup and printing of documents Compressing files; identifying and selecting suitable file formats and using them for transferring data 3.0 Proficiency in general IT skills 3.1 Word processing skills such as creating a document, using spellcheck, creating tables, working with headers or footers, mail merge, document formatting etc. and common word processing related keyboard commands; 3.2 Numeric Skills to deal with numbers and digits, using formulas, references, macros, tables, graphs through spreadsheets and common keyboard commands for spreadsheets. Presentation skills for sharing and understanding data in form of charts, graphs and data. 3.3 Internet skills such as using search engine effectively to get the best desired result within short time; uploading and downloading information from the Internet and usage of Internet applications such as web sites, browsers, blogs, and Internet services such as Email, video conferencing, Online Collaboration etc. 4.0 Reading Comprehension 4.1 Ability to read and understand passages in English comprising questions regarding locating information, identifying relationships, interpreting ideas, moods, characteristics of characters, tone of passage and getting the central theme 5.0 Mathematical & Reasoning Aptitude 5.1 Mathematical Aptitude comprising concepts from Annuities, Ratio & Proportions, Time, Work & Distance, 2 D & 3D Figures- Areas & Volumes) 5.2 Reasoning Aptitude focusing on Verbal and Logical Reasoning focusing on deriving conclusions from logical premises or assess the validity of arguments based on statement of facts. 6.0 General Awareness 6.1 Indian History & Indian Geography, Indian Economy, Indian Constitution, Science & Technology, Trends in Current Affairs 7 Keyboard Skills 7.1 Typing in English 7.2 Typing in Hindi Disclaimer The above syllabus describes broader areas of Computer Proficiency for CPCT Exam. The questions appear in CPCT Exam may or may not lay directly in the described broader areas of syllabus.

[@mybigguidehindi]

हम पूरी कोशिश करेगें कि इन विषयों पर वीडीयो बनायें सिलेबस उपलब्‍ध कराने के लिये धन्‍यवाद

[@TechnicalDehat]

Thanks sir

[@0007varun]

THANK YOU SIR

[@yusuf0904]

Thanks Sir ❤

[@rakeshsinha8967]

Nice

[@kirtanpatel8191]

Nice

[@SanjayKumar-tb9fe]

Nice