Excel me divide karne ka formula hai =A1/B1 (forward slash). Jaise aap calculator me ‘/’ use karte hain, waise hi Excel me bhi division ke liye forward slash (/) use hota hai.
Division Ka Basic Formula
Excel me kisi bhi number ko doosre number se divide karne ke liye aap directly cell mein formula likh sakte hain. Maan lijiye cell A1 mein 10 hai aur cell B1 mein 2, to aap cell C1 mein =A1/B1 likhenge aur Enter dabayenge. Result 5 aayega.
Formula hamesha = (equals) se start hota hai. Agar aap = nahi lagayenge, to Excel usse text samajh lega aur division nahi karega.
Division Ke Liye Cell References Ka Use
Numbers ko seedha formula mein likhne ke bajaye cell references use karna behtar hai. Isse agar aap cell ka value badalte hain, to formula automatically update ho jata hai. Example:
- Cell A1: 100
- Cell B1: 4
- Cell C1:
=A1/B1→ Result: 25
Yeh approach tab bahut kaam aati hai jab aapke paas bahut saara data ho, jaise ek column mein sales aur doosre column mein quantity.
Ek Saath Kai Rows Mein Divide Karna
Maan lijiye aapke paas column A mein 10 numbers hain (A1:A10) aur column B mein 10 numbers (B1:B10). Aapko har row ka division chahiye. Uske liye cell C1 mein formula =A1/B1 likhein, Enter dabayen, aur phir C1 ke bottom-right corner par jo chhota green square hai (fill handle), usse drag karke C10 tak le jayen. Excel har row ke liye formula adjust kar dega: C2 mein =A2/B2, C3 mein =A3/B3, aur aise hi.
Divide By Zero Error (DIV/0!)
Agar aap kisi number ko zero se divide karte hain, to Excel #DIV/0! error dikhata hai. Yeh isliye hota hai kyunki mathematics mein zero se division defined nahi hai. Is error se bachne ke liye aap IFERROR function ka use kar sakte hain.
Formula: =IFERROR(A1/B1, "N/A")
Iska matlab hai: agar division successful hai to result dikhao, warna “N/A” dikhao. Aap “N/A” ki jagah kuch bhi likh sakte hain, jaise “Error” ya blank (“”).
Percentage Ya Ratio Nikalne Ke Liye Division
Division ka sabse common use percentage nikalna hai. Maan lijiye aapke paas total sales 2000 hai (cell A1) aur ek product ki sale 500 hai (cell B1). Us product ka percentage nikalne ke liye formula hai =B1/A1. Result 0.25 aayega. Isse percentage mein dikhane ke liye cell ko select karke Home tab > Number group mein “%” symbol par click karein, ya Ctrl+Shift+% (Mac: Cmd+Shift+%) dabayen. Result 25% dikhega.
Ratio nikalne ke liye bhi aap division use kar sakte hain. Jaise agar A1 mein 8 hai aur B1 mein 2, to =A1/B1 se 4 aayega, matlab ratio 4:1.
Division Ke Saath Aane Wali Common Problems
- Galat result: Agar aapko lagta hai ki result galat hai, to check karein ki cell mein numbers sahi format mein hain. Kuch cells text format mein ho sakte hain, jisse calculation nahi hoti. Aap cell ko select karke Number format mein badal sakte hain.
- Decimal ke bajaye fraction: Excel default mein decimal dikhata hai. Agar aapko fraction chahiye, to aap cell format ko Fraction mein change kar sakte hain (Home > Number Format > Fraction).
- Division ki jagah multiplication: Agar aapne galati se * (asterisk) use kar diya, to multiplication hoga. Division ke liye hamesha / (forward slash) use karein.
Division Ke Alternatives
Kuch cases mein aapko division ke alternatives bhi use karne pad sakte hain:
- QUOTIENT function: Yeh sirf integer part return karta hai, decimal ko ignore karta hai. Example:
=QUOTIENT(10,3)→ 3 (kyunki 10/3 = 3.33, integer part 3). - MOD function: Yeh division ke baad remainder return karta hai. Example:
=MOD(10,3)→ 1 (kyunki 10 mein 3 teen baar jata hai, remainder 1). - Percentage change: Agar aapko do values ke beech percentage change nikalna hai, to formula hota hai
=(new_value - old_value) / old_value. Isse aap Excel ke andar hi percentage change nikal sakte hain.
Frequently Asked Questions
1. Excel me divide ka shortcut kya hai? Excel mein division ke liye koi dedicated shortcut nahi hai. Aapko formula likhna hota hai. Lekin agar aapko quickly divide karna hai, to aap cell mein = type karke pehla number, phir /, phir doosra number type kar sakte hain. Enter dabate hi result aa jayega.
2. Agar main ek number ko doosre se divide karun aur result mein decimal na aaye to kya karun? Aap QUOTIENT function use kar sakte hain, jo sirf integer part return karta hai. Ya aap cell format ko Number se change karke decimal places 0 kar sakte hain (Home > Number Format > More Number Formats > Number > Decimal places: 0).
3. Divide by zero error ko kaise hatayein? Aap IFERROR function ka use karein. Jaise =IFERROR(A1/B1, 0) – isse agar zero se division hoti hai to 0 return hoga, error nahi.
4. Kya main ek range ko divide kar sakta hoon? Jaise A1:A10 ko B1 se? Haan, aap array formula use kar sakte hain. Excel 365 mein aap =A1:A10/B1 type karke Enter dabayenge to saare results ek saath aa jayenge (dynamic array). Purane Excel versions mein aapko Ctrl+Shift+Enter dabana padta tha. Lekin simple tarika yeh hai ki har row ke liye formula copy karein.
5. Division ka result percentage mein kaise dikhayein? Result wale cell ko select karein, Home tab > Number group mein % symbol par click karein. Ya Ctrl+Shift+% (Mac: Cmd+Shift+%) dabayen. Excel number ko 100 se multiply karke % sign laga dega.
Related
- Excel Data Validation Start Date: How to Set It Up
- Excel Daily Checklist Template: How to Build One
- Excel Customer Information Template Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Tracking Hours in a Daily TimesheetFor a basic Excel timesheet, put a start time in B2 and an end time in C2, then…
- Sort an Excel Column Highest to Lowest: Quick StepsTo sort numbers in Excel from highest to lowest, select a cell in the column and choose Data…
- Excel FILTER Function: Multiple Criteria and ExamplesYes. In Microsoft Excel for Microsoft 365, use the FILTER function with multiplication (*) to require multiple conditions…
- Excel Conditional Formatting Due Date FormulaThe core formula for highlighting overdue dates in Excel is =A2<TODAY() applied to a range starting at A2,…
- Excel AVERAGEIF Formula Examples: Criteria, Ranges, FixesUse Excel’s AVERAGEIF function to average values that meet one condition: =AVERAGEIF(A2:A6,"North",B2:B6). If A2:A6 contains regions and B2:B6…
- Excel Date Minus 1 Month? Formula and Date RulesTo subtract one calendar month from an Excel date, use =EDATE(A1,-1), where A1 contains a real Excel date.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.