Combining several cells into single equasion?
 

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

Combining several cells into single equasion?
 

Nagel not quite clear what you are trying to achieve?
I don't believe there is a 'tool' to nest or combine the steps together
automatically other than writing a macro (VBA).
However, on the face of it you appear to have answered your own question
with the formula in L1.
Given your data you could abreviate it thus:
L1: =IF(ABS(H1-G1)180,360-ABS(H1-G1),ABS(H1-G1))
Failing this please give further clarification of your objective.



"Nagel Oxles" wrote:

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