Rounding

[jimfulton9]

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]

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]

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]

Welcome to MrExcel - tell us what it is you want to do, maybe we can figure out a solution.

 

[jimfulton9]

NBVC,

That did the trick. Thank you very much.