Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Cell Referencing

Posted by nfs
nfs
35,526 Points

Why is there an error in making a percentage value in column E??

When I'm trying to make the percentage value as mentioned in the video, I'm getting the first one right but the others are wrong..... What to do now?

2 Answers

Steven Parker
Steven Parker
231,269 Points
Steven Parker
Steven Parker
231,269 Points

Check your references.

If you get the first one right but not the rest, I would first check to see if you have used an absolute reference ("$") where you might have needed a normal one, or used a normal one where you needed an absolute one.

Either way, the first item might be right, but when you replicate the formula down the column the others would be computing the wrong thing.

nfs
nfs
35,526 Points
nfs
nfs
35,526 Points

Hey thanks for that, figured it out shortly after asked the question, tnx for your time though

Mister Moody
Mister Moody
48,333 Points

@nfs I would like to encourage you to explain how you solve problems because guys like me will come behind you with the same issue....given that your question is more than 2 years old, I'll digress.