Complex excel - calling formulae result and setting as value of aspecific cell

[Michael Harris]

To cut a long story short, I need to convert mapping coordinates in a
specific projection (the Australian Map Grid, or AMG) to a Lat/Long in
degrees/minutes/seconds using Redfearn's Formula.

There is already an excel worksheet out there which converts these on
a one-by-one basis, which is available from:
http://www.ga.gov.au/geodesy/datums/redfearn.xls

What I'd like to do is set the value of a cell based on the formula
output, eg:

=redfearn_lat(X,Y,Z)
=redfearn_long(X,Y,Z)

With X being the cell reference for the easting value, Y for the
northing value, and Z being the Zone.

Any help appreciated.

 

[macropod]

Hi Michael,

If you unhide the hidden rows in that worksheet, you'll see there are numerous constants and intermediate formulae used to do the
transformation, some of which refer back to the 'Constants & Parameters' worksheet. Thus, what you've got is not so much a formula
as a set of lookup tables. Unless you've got access to the underlying formula, all these factors would need to be coded into your
UDF.