The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Difference in Excel functions?

Difference in Excel functions?

0
Votes
1
Answer

What is the difference between:

For example: $d$3 and d3 in any function?

1 Answer

365 Team
0
Votes

Hello, Lal!
 
$ – sign locks that row and column so that when you drag the formula in excel it doesn’t get change.
 
For example if you drag the formula from top to bottom and doesn’t put $ sign D3 gets changed to D4 and if left to right D3 will change to E3.
 
Hope this helps!
Best,
365 Team

×
EXTENDED SALE
Learn Data Science this Summer!
Get 50% OFF