
Excel - Trend Formula
- or -
Post a project like this2605
£25(approx. $34)
- Posted:
- Proposals: 4
- Remote
- #2213604
- Awarded
Description
Experience Level: Entry
Hi,
I require a formula in the attached spreadsheet to fill in the blank numbers.
The spreadsheet contains numbers from 0 to 135 with values entered in increments of 15. I now want to see if there is a formula that can be used to work out the other values (which would produce a tangential curved line rather than a straight line if entered into a chart).
The values I have entered are for example only. They have no meaning and the formula would need to be such that I can easily change those numbers and the numbers around them would also change to suit.
0 = 0
15 = 0.24
30 = 1.28
45 = 1.93
60 = 2.34
75 = 2.89
90 = 3.01
105 = 3.93
120 = 4.75
135 = 5.21
ie. what would 97 equal?
ie. if I changed 105 to 3.84, the value for 97 would also change.
I hope that makes sense. Please let me know if there are any questions.
I require a formula in the attached spreadsheet to fill in the blank numbers.
The spreadsheet contains numbers from 0 to 135 with values entered in increments of 15. I now want to see if there is a formula that can be used to work out the other values (which would produce a tangential curved line rather than a straight line if entered into a chart).
The values I have entered are for example only. They have no meaning and the formula would need to be such that I can easily change those numbers and the numbers around them would also change to suit.
0 = 0
15 = 0.24
30 = 1.28
45 = 1.93
60 = 2.34
75 = 2.89
90 = 3.01
105 = 3.93
120 = 4.75
135 = 5.21
ie. what would 97 equal?
ie. if I changed 105 to 3.84, the value for 97 would also change.
I hope that makes sense. Please let me know if there are any questions.
Ian W.
100% (17)Projects Completed
24
Freelancers worked with
24
Projects awarded
43%
Last project
29 Sep 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies