CHAPTER 7 · INTERMEDIATE EXCEL
Relative, Absolute & Mixed References
Formula copy karte waqt reference kaise move kare ya lock rahe — ye Excel ka core skill hai. Is chapter me A1, $A$1, A$1 aur $A1 ko practical examples ke saath samjhenge.
Relative reference
=B2*C2 ko neeche copy karne par next row me automatically =B3*C3 ban sakta hai. Ye relative reference hai.
Hinglish
Relative reference formula ke saath move karta hai. Repeated row calculations ke liye ye default aur useful behavior hai.
Absolute reference
Jab ek fixed value — jaise tax rate, commission rate ya conversion factor — har formula me same rehni chahiye, cell ko dollar sign se lock karo.
exampleExcel
=B2*$E$2Yahan B2 row ke saath change ho sakta hai, lekin $E$2 locked rahega.
Mixed references
$A1→ column A locked, row change ho sakti hai.A$1→ row 1 locked, column change ho sakta hai.$A$1→ row aur column dono locked.
Where this matters
- GST/tax calculations
- Discount rate
- Exchange rate
- Multiplication tables
- Commission slabs