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.
Peacock_sqrtBug.vwx