J jimfulton9 New Member Joined Nov 15, 2005 Messages 2 Nov 15, 2005 #1 How do I get around the circular reference. My formula is for example: =b10-(a10/2)=rounddown(b11,0) this formula is in cell b11 and that is where I want my answer to be.
How do I get around the circular reference. My formula is for example: =b10-(a10/2)=rounddown(b11,0) this formula is in cell b11 and that is where I want my answer to be.
NBVC Well-known Member Joined Aug 31, 2005 Messages 5,828 Nov 15, 2005 #2 You can't reference the cell you are in when writing a formula. What is it your are trying to do? Maybe you want this: =Rowndown(b10-(a10/2),0)
You can't reference the cell you are in when writing a formula. What is it your are trying to do? Maybe you want this: =Rowndown(b10-(a10/2),0)
barry houdini MrExcel MVP Joined Mar 23, 2005 Messages 20,825 Nov 15, 2005 #3 Welcome to the board, you can't normally reference a cell in that cell's formula, hence the circular reference, perhaps you want =int(b10-a10/2)
Welcome to the board, you can't normally reference a cell in that cell's formula, hence the circular reference, perhaps you want =int(b10-a10/2)
just_jon Legend Joined Sep 3, 2002 Messages 10,473 Nov 15, 2005 #4 Welcome to MrExcel - tell us what it is you want to do, maybe we can figure out a solution.
J jimfulton9 New Member Joined Nov 15, 2005 Messages 2 Nov 15, 2005 #5 NBVC, That did the trick. Thank you very much.