excel - circural references

Copper Contributor

Bez naslova.jpg

5 Replies
I can not find where problem is, I have tries with formula checkin, but nothing

@ivana1705 

Do you mean this option

image.png

under "formula checkin" ?

@Sergei BaklanThank  you, I have find it in Circular references, this formula =MAX($B6:B$19)+1, what does it mean, can I delete it?

@ivana1705 

Which cell contains that formula?

@ivana1705 

Most probably you formula is in one of the cells with the range, e.g. in B19. Move it out of range, e.g. in B20.