MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.