Good to see, and thanks for the post.


ktatey Wrote:[color=blue]
Hi
That hit the spot, I greatly appreciate your help and thanks heaps.
Cheers
ktatey

"Bryan Hessey" wrote:
[color=blue]

Hi,

try

REBELS DR230 =IF(DS226=1,2,IF(DR228=1,1,0))


the 'or(' appears superfluous


ktatey Wrote:
Hi
Here are the cells and the formula's in those cells
Cell CO12 is the one I need to consolidate, it has a 1 in it,
usually
there
is a 2 in it and it consolidates fine

Cell Formula
CO12 =CE12
CE12 =IF(CB120,REBELS!$DR$230,0)
REBELS DR230 =IF(DS226=1,2,OR(IF(DR228=1,1,0)))


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=400005