SOLVED

cercular function error

Copper Contributor

hi, i get a notification of such an error but i can't find the cell where it is.

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@amnon_firan 

Activate the Formulas tab of the ribbon.

In the Formula Auditing group, click the drop-down arrow on the right hand side of the Error Checking button.

If you select Circular References, you should see which cell(s) cause the problem.

HansVogelaar_0-1700563339792.png

thank you. problem solved.
1 best response

Accepted Solutions
best response confirmed by Sergei Baklan (MVP)
Solution

@amnon_firan 

Activate the Formulas tab of the ribbon.

In the Formula Auditing group, click the drop-down arrow on the right hand side of the Error Checking button.

If you select Circular References, you should see which cell(s) cause the problem.

HansVogelaar_0-1700563339792.png

View solution in original post