How do I create a function (equation) that goes through my three points. I want my function to be some sort of root fuction where the root is less than 1.
e.g. y = x ^(1/3)
the points a
y = 0.25; x =100
y = 0.5; x = 150
y = 0.9; x = 350
I am new to this forum and I really hope someone can help.
I have a spreadsheet with a colum that has tons of fractions that look like this(22/8, 45/6, 313/9, etc.) you get the point. What I am asked to do is go through this colum and change each one to a whole number (ex. 22/8 would be changed to 23, 45/6 is changed to 46). Basically what I want to do to save so much time(and I'm not sure if this is possible) is to make a function that will find the fraction, for instance 22/8, multiply it by the bottome number (8) and then add 1. I really hope someone can help. If i'm unclear, let me know and I will try to explain better. Thanks sooo much in advance.
The problem with my Excel is that I noticed a sum function that gave a clearly incorrect answer. The sum function (red) adds the yellow and blue values, which anyone with 3rd grade math knows is 257.7. However, the result of the function is 253.3 in the red box.
The yellow and blue boxes are summing many rows of numbers themseves, perhaps that has something to do with it?
Help! It's very difficult to work with Excel when I can't trust the results of the functions I run.
http://i91.photobucket.com/albums/k2...sc/problem.jpg
Can any one help me with a problem? What I have is 5 cell A5 to E5 in a row
with 500 in each one, then I have column with 7 cell B7 to B13 with different
numbers in it, then have two cell D7 to D8 with drop list in each one for
cell in roll A5 to E5. Now when I put numbers in column B7 to B13 it
subtracts from one drop list of which cell I pick to take away from D7 of
500, ? is how do you get it to subtract from cell B8 when B7 gets to zero? If
I had 100 in each cell from B7 to B13 thats 700 , B7 has 500 and B8 has 500,
I dont what D7 to show -200 want it to pick up from B8. This make any sense?
Hi i want to create formula something like this
=((B5*$AJ$5)+(B6*$AJ$6)+(B7*$AJ$7)+(B8*$AJ$8))
Itz working fine without any problem.
Now the my query is i want to continue to formula till 98 column some thing like this
=((B5*$AJ$5)+(B6*$AJ$6)+(B7*$AJ$7)+(B8*$AJ$8)...........+(B97*$AJ$97)+(B98*$AJ$98))
So can any one please let me know who do i create that formula. du i need to manually enter upto 98 columns orelse is there any other function which can solve my problem
Thanks in advance
I am not a math guru by no means. i have a formula that i am trying to place in excel, however i am not sure what the function is I need to call or if there is one.
the formula is G(sec Z)
can anyone help me with this issue.
Hi i'm a somewhat new Excel user that is trying to figure out somethign with no luck so far. What i'm trying to do is to set up the following math function
=(A1*1.1)*2.6)
But I want A1 to be whatever column i'm entering the number in. Is there a notation for the selected column? If so then can i just copy and paste in every column or is there a way to set it up so every column has that formula.
So in column A1 i would enter in 927 column A2 would be 937 ect. So I can change the value in each column to get an answer. Hope this makes sense.
Hello,
I'm trying to do some date math and not having any luck.
I have a date/time number like 40338.6424421296000000
I want to strip it into 2 cells, one with the date, one with the time.
If I TRUNC() the number, I get the date
If I MOD(xx,1), I get the time.
So far so good, problem is, the time that I'm getting (it's coming in from another source that I can't alter) is in GMT. I want it in my local time (Eastern for now but could be any time zone in the world). I'm not having any luck being able to either format the cells for local time or doing either a subtraction or addition to get the local time.
Any ideas?
Thanks!
Frenchie4016
I want to determine the second Wednesday of a month. I did a search and found the following:
Assuming A1= 4/1/2008
=A1-Weekday(A1-4)+14 does the trick perfectly.
However, when I try to do the math I get a different answer.
4/1/08 (A1) has a sequential number of 39539
A1's Weekday value = 3. It falls on a Tuesday this year.
When I plug in these values:
39539-(3-4)+14 I get 39554. That = 4/16/08.
What am I doing wrong, that Excel gets right??
As always you help is greatly appreciated.
k
I am trying to find the number of days between to dates. The problem is the dates are given in a format that i have a hard time working with. The format ie. 200712 through 200802. The format is always 6 characters and it always starts with a year and ends with a month without the days. My goals is count the number of days between the two dates. Does anyone have any ideas? Thx again, john
