LinkBack URL
About LinkBacks
Hello, I am new to the forum and am in need of help creating a formula. Below is the equation I need in excel. D and E are the columns I am working with.
D-E=Z
Z/2=Y
Y+E=X
Any help is greatly appreciated.
Hello, I am new to the forum and am in need of help creating a formula. Below is the equation I need in excel. D and E are the columns I am working with.
D-E=Z
Z/2=Y
Y+E=X
Any help is greatly appreciated.
hello
you have values in column D and E
in column F
=D1-C1 drag down...
in column I
=F1/2 drag down
in column J
= I1+E1 drag down.
is this what you want?
if not maybe post a sample workbook and maybe explain it further.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you for the help. To better explain what I'm trying to do here is this.
In column F, for each row, I need a number from the following equation. (these are the steps for the equation but it is all 1 equation not 3 seperate)
First Step
D-E=?
Second Step
Take the result of D-E and divide it by 2
Third Step
Take that result and add the number in E to get the number i want in F
Using numbers its like this
(D)$55.95-(E)$46.95=$9.00
$9.00/2 = $4.5
$4.5+46.95= $51.45
=((d1-e1)/2)+e1
Thank you! Perfect
welcome.
stick to the forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks