how to: circular reference
 

I'm having some difficulity in mulitplying two cells together, while entering
a number in the same cell. I guess it is called circular reference... They
say it is possible as long as you tell the cell how many times it will
change. How do I do this. Example... B2*B4. B2 = $55.00 B2= 4 I Want B2
to calculate the new total.

Take a look here (change + to *):

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
Tim wrote:

I'm having some difficulity in mulitplying two cells together, while entering
a number in the same cell. I guess it is called circular reference... They
say it is possible as long as you tell the cell how many times it will
change. How do I do this. Example... B2*B4. B2 = $55.00 B2= 4 I Want B2
to calculate the new total.

The part where it says to type B1: =A1 = B1 where do u type that

"Tim" wrote:

I'm having some difficulity in mulitplying two cells together, while entering
a number in the same cell. I guess it is called circular reference... They
say it is possible as long as you tell the cell how many times it will
change. How do I do this. Example... B2*B4. B2 = $55.00 B2= 4 I Want B2
to calculate the new total.

In B1 enter formula =B1*A1
HTH
"Timwig" wrote:

The part where it says to type B1: =A1 = B1 where do u type that

"Tim" wrote:

I'm having some difficulity in mulitplying two cells together, while entering
a number in the same cell. I guess it is called circular reference... They
say it is possible as long as you tell the cell how many times it will
change. How do I do this. Example... B2*B4. B2 = $55.00 B2= 4 I Want B2
to calculate the new total.