excell round fuction question
excell round fuction question
(OP)
I am trying to set up a spreadsheet to automatically do interpolation from a table. I think I need to somehow use roundup with mround to get the correct results. If you take a look at the attached excel spread sheet you can get a better understanding to what I am doing as it is hard to explain! Ok here we go. Cells A15 & A17 are the equations I need to fix. If you look at row 6 the increments are in .05 increments so cells A15 & A17 need to end up with the .05 increments. A15 needs to round down to the .05 increment value and A17 needs to round up to the .05 increment. Does anyone have ideas?





RE: excell round fuction question
Cell A15 =Roundown(a16/0.05,0)*.05
Cell A17 =Roundup(a16,0.05,0)*.05
When I did this, I got a result of 0.10 for Cell A15, and 0.15 for Cell A17
RE: excell round fuction question
In cell b15, change "false" to "true"
In cell b20, change the statement "A17-A16=0" to "A17-A16=B17"
RE: excell round fuction question
Cell B20 should look like the following:
=IF(OR(A17-A16=0,A17-A15=0,B17-B15=0),B17,B17-((A17-A16)/((A17-A15)/(B17-B15))))
RE: excell round fuction question
=ROUND(32.484*A16^4-64.968*A16^3+32.48*A16^2+0.0039*A16-0.0019,2)
RE: excell round fuction question
Thank you for the tip it worked perfect! I am not sure what the difference is using true or false because it seems to give the same answer. Do you know the logic behind true or false?
RE: excell round fuction question
In cell A14 add: =+MATCH(A16,B6:R6)
Then modify as follows:
A15: =INDEX($B$6:$R$6,$A$14)
A17: =INDEX($B$6:$R$6,$A$14+1)
B15: =IF(A15=0,0,INDEX($B$7:$R$7,A14))
B17: =IF(A17=0,0,INDEX($B$7:$R$7,A14+1))
B20 can stay the same.
I have attached a copy of the spreadsheet, modified as described above.
Also the spreadsheet IP.xls at h
contains functions for linear and other types of interpolation.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: excell round fuction question
A15 = FLOOR(A16,0.05)
and
A17 = CEILING(A16,0.05)
?
RE: excell round fuction question