Hi,

Is this formula is in A6?, if not where is it?

With the data you give for Q6 - R6 it will always produce 0 as a result.
Simplify the formula like this

=IF(ISERROR(S6),0,(R6/Q6))

What is the formula in S6?

Mike

"Alexey" wrote:

Hi
When i open a worksheet I am getting a Circular reference error
The reference is on $s$6 and the forumula is: =IF(ISERROR(S6),0,SUM(R6/Q6))

Q6 contains the figure 87 R6 contains 0

Can someone explain this to me please I dont understand why it is a circular
reference

Thanks

A