| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
Which function? Biggest distance to the Nearest city ...
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding state that contains employees biggest sale | Excel Discussion (Misc queries) | |||
| zip code to city, state function | Excel Worksheet Functions | |||
| Finding a name with biggest number | Excel Worksheet Functions | |||
| Would u help me with a Biggest Movers type of comparison? | Excel Discussion (Misc queries) | |||
| WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
Threaded Mode
