Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the correct syntax for an allowable circular reference? | Excel Discussion (Misc queries) | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Circular reference | Excel Discussion (Misc queries) | |||
Circular reference | Excel Worksheet Functions |