Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining different charts on a single chart | Charts and Charting in Excel | |||
Query equasion for dates | Excel Worksheet Functions | |||
how do i make a formula thart rep equasion X/b=12 if b = cell c12 | Excel Worksheet Functions | |||
Combining like worksheets into a single worksheet | Excel Worksheet Functions | |||
Combining numerical and drop-down text in a single cell | Excel Discussion (Misc queries) |