Yes, David, but the OP put it in the form I used in his posting.

Pete

On Oct 11, 1:43 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
"Pete_UK" wrote in message
...
You can apply your formula to each cell, something like:

=(($B4-D$2)^2 +($C4-D$3)^2)^0.5

...

Or, if you prefer, =SQRT(SUMSQ($B4-D$2,$C4-D$3))
--
David Biddulph