Rounding

jimfulton9

New Member
Joined
Nov 15, 2005
Messages
2
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.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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
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
Welcome to MrExcel - tell us what it is you want to do, maybe we can figure out a solution.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,137
Messages
5,576,299
Members
412,716
Latest member
Ardin
Top