Hi folks,

Can Excel be instructed to nest several cell processes together to form a
single final equation to display a result? I have generated a sample to
show what I mean: -

Two positions of an arm are measured and entered in cells A1: to C1: and
D1: to F1:

The individual steps to calculate the reflex angle (internal angle) of
the arms are shown in G1: to K1:

A1: (enter degrees) Pos A
B1: (enter minutes) Pos A
C1: (enter seconds) Pos A

D1: (enter degrees) Pos B
E1: (enter minutes) Pos B
F1: (enter seconds) Pos B

G1: =A1+B1/60+C1/3600
H1: =D1+E1/60+F1/3600
I1: =H1-G1
J1: =ABS(I1)
K1: =IF(J1180,360-J1,J1)

I can manually nest all of these steps together in a single cell so that
it only processes the data in the cells A1: to F1:.

L1: =IF(ABS((D1+E1/60+F1/3600)-(A1+B1/60+C1/3600))180,360-ABS((D1+E1/60
+F1/3600)-(A1+B1/60+C1/3600)),ABS((D1+E1/60+F1/3600)-(A1+B1/60+C1/3600)))

Is there a way (tool) to get Excel 2003 to nest or combine all of the
steps together automatically?

My question is how to get Excel to do this, not to look at alternative
ways to manually process the data.

I have run out of ideas how to find an answer. Hope someone can explain
it to me.

TIA.


--
Many thanks for your help, Nagel