Archive of Mr Excel Message Board
Back to Errors in Excel archive index
Back to archive home
an easy percent question
Posted by Trevor on October 25, 2001 8:24 AM
I am keeping a monthly log of sales (column b - m) that total in column n.
I would like to convert the monthly entries to a percentage of the changing year to date total.
I'm getting the "circular reference" error thing and am not sure how to get what I want
Thoughts/comments/suggestions
Re: an easy percent question
Posted by Dan on October 25, 2001 9:18 AM
You're probably getting the circular reference error because you are trying to put your formula in the same cell that you have your values. For instance, if are trying to convert the value "300" in cell M1 to a percentage of your total, then you will need to put the formula in a different cell and reference M1. Does that make sense? In other words, if you don't want to mess with coding, then you will need to have separate cells for the actual value (i.e. "300"), and another for the percentage value.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.