Jump to content

Sqrt function works in one sheet, not in another - [solved - was circ. ref.]

Recommended Posts

I have two near identical worksheets  where =SQRT works in one and not the other.


=SQRT works with one cell which is calculated from other cells, and fails on all the other cells where I want to use it. It's infuriating. Can anyone see what's going on?

It Does work on other cells if I simply enter the number but that defeats the purpose of having a computer. 


Worksheets are standalone with no links, Cells formatted the same, both set as decimal to same signif. places.


My desired solution is to generate mean planting distances for each of my planting types (which I have working the exactly same setup in other jobs).


I'm doing this in worksheets as I usually understand and trust them more than the DB which I've had very bad (co$tly) experiences with.


Link to comment

Hi Pat, Thanks so, so much for seeing that. I went round and round looking, comparing the two sheets and I missed that - yes it's perfect again now 🙃.

I need to set up some sort of validation so that doesn't happen again.


Are worksheets more functional in later versions? Helping one avoid, or at least find such errors?

Link to comment
  • unearthed changed the title to Sqrt function works in one sheet, not in another - [solved - was circ. ref.]

Worksheet have changed the interface fairly significantly since VW2012 to make it easier to SUM and SORT in databases using a more typical interface than dragging the tiles to the columns, but Worksheet formulas are effectively a programming language. Nothing has been added to help prevent programming errors.


I tested your file in VW2021 and I was still scratching my head about what was going on.

  • Like 1
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...