• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5120
  • Last Modified:

How to code mathematical function "ln" in VB?

Hi experts,
I want to write a formula in VB and my formula contain mathematical function "ln" .. i just don't know how to code it in VB..
i know for "log".. just put something like log(2).. but cannot with "ln"..

thanks
0
michelle_branch
Asked:
michelle_branch
1 Solution
 
diarmaidCommented:
In is a reserved word in VB + SQL
Can you give an example of what context you wish to use it?
0
 
_agj_Commented:
ln is natural log.

log() fn in vb is natural log itself.

so u can use it.

if u want log to the base 10, do a log(x)/log(10)
0
 
JonGartziaCommented:
log is ln in VB.

log(e)=1
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
enariCommented:
The closest thing to IN would be a case statement

select case (val)
    case  1 to 15: do something
    case 20,30,40,50: do something else
    case else:  not "IN" above"
end select

I know it's not exactly math, but it works as a replacemet.
ie "IF x in {1,5,34,34,36 } can translate to

if x = 1  or x=5 or x=34 or x=36 then
   do something
end if

(or)

select case x
case 1,5,34,34,36 : do something

hope that helps!
0
 
enariCommented:
The closest thing to IN would be a case statement

select case (val)
    case  1 to 15: do something
    case 20,30,40,50: do something else
    case else:  not "IN" above"
end select

I know it's not exactly math, but it works as a replacemet.
ie "IF x in {1,5,34,34,36 } can translate to

if x = 1  or x=5 or x=34 or x=36 then
   do something
end if

(or)

select case x
case 1,5,34,34,36 : do something
end select

hope that helps!
0
 
_agj_Commented:
no spec. grudges, but why did u opt for grade B.?
as in, i thot the answer was total.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now