Excel 2007 : Help with if formula please

[haxz_rsx]

Hi,

I am trying to create the IF formula below but it is not to working.

=IF(BO10-(BV10-CJ10+BH10)<0,0,BO10-(BV10-CJ10+BH10))

The "Error" I am getting is the Circular reference.

Please help

[davesexcel]

Is there a circular reference?

[protonLeah]

I.e., What cell is the formula in?

[haxz_rsx]

Hi, yes for some reason?

It's in Cell CCQ10.

[haxz_rsx]

sorry I meant, it is "CQ10"

[haxz_rsx]

I've tried many to do it in different cells and the result if always the same?

Not sure what I am doing wrong...

[davesexcel]

What is in cq10?
Please don't assume we know what your worksheet looks like.

[haxz_rsx]

nothing is in CQ10, I am trying to enter the formula into there.

It's ok, I found out that it was my mistake, some of the cells in my IF formula use CQ10 in it.

I have to convert them to values.

Thanks though.