1 страниц (4 вхождений)
Showing functions for large formulas - See post for attempt at a description. - Сообщения
#1 Опубликовано: 26.05.2015 10:51:36
Hello all,
I am very new to the forums and I apologize if this has been answered but I was unable to find it with a cursory search of the forums. I didn't know how to title this post so I hope that my explanation will suffice.
I am working on making some transfer functions for a circuit and as a build on it at each point it gets messy. Currently I have been copying and pasting the formula as it progresses so I can see what is happening, but if I change something in an earlier formula it does not populate down the document. I have been trying to work around this by doing the following:
Example:
a:=2
b:=3
c:=5
d:=5
f:=a+b
g:=2f+c
h:=(g+5)/d
What I have been doing would lead to h:=((2(a+b)+c)+5)/d
h:=(g+5)/5 is nice and condensed but I need to be able to see the whole function in the end.
Is there a way to expand h:=(g+5)/5 into h:=((2(a+b)+c)+5)/d?
This way any changes I make in the beginning of the sheet would populate down without having to manually change each formula.
I appreciate any and all help!
I am very new to the forums and I apologize if this has been answered but I was unable to find it with a cursory search of the forums. I didn't know how to title this post so I hope that my explanation will suffice.
I am working on making some transfer functions for a circuit and as a build on it at each point it gets messy. Currently I have been copying and pasting the formula as it progresses so I can see what is happening, but if I change something in an earlier formula it does not populate down the document. I have been trying to work around this by doing the following:
Example:
a:=2
b:=3
c:=5
d:=5
f:=a+b
g:=2f+c
h:=(g+5)/d
What I have been doing would lead to h:=((2(a+b)+c)+5)/d
h:=(g+5)/5 is nice and condensed but I need to be able to see the whole function in the end.
Is there a way to expand h:=(g+5)/5 into h:=((2(a+b)+c)+5)/d?
This way any changes I make in the beginning of the sheet would populate down without having to manually change each formula.
I appreciate any and all help!
#2 Опубликовано: 26.05.2015 13:04:37
#3 Опубликовано: 27.05.2015 09:59:50
After you define h in terms of g and d is there some trick to show the rest or did you still manually input the function in terms of a, b, c, and d? When I input what you have for h and hit the equal sign again, it says that c is not defined. What I am trying to avoid is having to input the function in this way. If I were to change the function f I would want it to show up in the definition of h and not have to change every instance of it.
#4 Опубликовано: 27.05.2015 10:01:31
Nevermind, I just figured it out. The arrow is what I need to press instead of the second equal sign. Thank you very much for your help. This helps me out immensely!
1 страниц (4 вхождений)
-
Новые сообщения
-
Нет новых сообщений