I hope this makes some sense. I'm using ln(c4/c5) and the value of that formula comes out correct. But when I reference that number later in the forumla (c2*c3*c6) (c6 is the ln() formula) I get a larger number than I expected. So ln(c4/c5) is .389, and my formula is 345*9.807*.389, which should be 1316. When I plug the numbers in as a cell reference I get 1318.
So to summarize:
345*9.807*389 = 1316
(c2*c3*c6) = 1318
Why am I getting different numbers?
Last edited by OGAngryHulk; 07-25-2018 at 05:29 PM.
What are the values in C4 and C5?
If posting code please use code tags, see here.
Actually, I wrote the formula wrong, its (c2*c3*c6). Now the values in c4 and c5 are 3.1 and 2.1 so that formula would be ln(3.1/2.1)
Here are the actual numbers
c2 345
c3 9.807
c4 3.1
c5 2.1
c6 0.389
c7 1318
C7 is the total of c2*c3*c6
Looks like a rounding issue.
When I have 3.1 in C4 and 2.1 in C5 I get 0.389464767 from LN(C4/C5).
Re: Using ln() function produces strange results
as above
=C2*C3*C6 =LN(C4/C5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks