Exel me $ ka nesha kis k lie use karte hai aur qn karte hain
Exel me $ ka nesha kis k lie use karte hai aur qn karte hain
Simple Dollers k liye Dollers ki amount k liye maslan $10
"Blue Fire" ne bilkul theek kaha hai, $ sighn dollars ko zahir karne k liye hota hai. lakin agar aap formulas main iss sign ki baat kar rahe hain to ye Absolute reference k liye use hota hai.
Shayad aap ko pata ho ga k Excel main do tarah ki reference hoti hain, aik ko Relative and dosre ko Absolute kehte hain aur excel inn dono references ko alag alag treat karta hai.
Aam toar par ziyada tar ham relative reference hi use karte hain. yani jab ham kissi cell main formula enter karte hain, jaise "=A1" aur phir jab issay kissi dosre cell main fill ya copy karte hain to excel khud hi issay =B2 kar deta hai.
aur jab ham ye chaahin k excel aisa na karay to ham "$" sign laga dete hain, phir aap jahan b issay copy karain gay to ye change nahi ho ga balke ussi cell ko refere karay ga.
Mazeed info aur pictures illustration k liye ye link visit karain.
http://www.homeandlearn.co.uk/me/mes9p1.html
http://www.awardsites.com/tutorials/...ell_ref-01.htm
REMEMBER...
The shortest distance between a problem and a solution
is the distance between your knees and the floor.
The one who kneels to Allah,
can stand up to anything.
Thanks Nadeem gul ap ne mery mushkil hal kar di
GGGGGGGGGGGGGGGoooooooooooooooooooooooooooood
Bookmarks