Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Cell Referencing

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
221,070 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.

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

Mister Moody
Mister Moody
41,727 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.