ROUNDUP Formula

[Phoon Chee Keong]

Is that a formula in vb.net like Ms Excel? Currently my Excel formula is
"=(((ROUNDUP(I30/3000,0)+1)*G30)/1000)+((ROUNDUP(G30/10000,0))*I30/1000)",
but in vb.net how to write.

Any idea?
Regards,
PCK

[Cor Ligthert [MVP]]

Phoon,

Please try to avoid multiposting. Although this is not such a relevant post
to this newsgroup can you by relevant subjects better use crossposting
(sending one message to more newsgroups).

Relevant is as well if you don't know which one.

For others this is answered by Ken in the language.vb newsgroup and replied
by Phoon that it was the needed answer.

Cor
"Phoon Chee Keong" <da******@streamyx.com> schreef in bericht
news:ut****************@TK2MSFTNGP10.phx.gbl...

Is that a formula in vb.net like Ms Excel? Currently my Excel formula is
"=(((ROUNDUP(I30/3000,0)+1)*G30)/1000)+((ROUNDUP(G30/10000,0))*I30/1000)",
but in vb.net how to write.

Any idea?
Regards,
PCK

[clintonG]

If you were a DocType you would be strict :-) Give the guy a break Cor. The
best part about .general is asking general questions so the ignorati who do
not know which specific question to ask can be answered directly or the OP
can be directed to another resource if the person trying to reply does have
a specific answer.

It also seems that people who cross-post are ready to sh!t their pants if
they can't learn how to do something their brain just refuses to even think
about anymore. They make medicine for that.

So I would recommend variants of this type of search...

search: rounding site:msdn.microsoft.com
search: math class site:msdn.microsoft.com

Might as well do

search: truncation site:msdn.microsoft.com

Finally I would try...

search: brain dead and lazy site:Phoon Chee Keong :-)

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/



"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:eq**************@TK2MSFTNGP10.phx.gbl...

Phoon,

Please try to avoid multiposting. Although this is not such a relevant
post to this newsgroup can you by relevant subjects better use
crossposting (sending one message to more newsgroups).

Relevant is as well if you don't know which one.

For others this is answered by Ken in the language.vb newsgroup and
replied by Phoon that it was the needed answer.

Cor
"Phoon Chee Keong" <da******@streamyx.com> schreef in bericht
news:ut****************@TK2MSFTNGP10.phx.gbl...

Is that a formula in vb.net like Ms Excel? Currently my Excel formula is
"=(((ROUNDUP(I30/3000,0)+1)*G30)/1000)+((ROUNDUP(G30/10000,0))*I30/1000)",
but in vb.net how to write.

Any idea?
Regards,
PCK

[Cor Ligthert [MVP]]

Clinton,

I never tell to people: "You should go to somewhere else you are not welcome
here".

I try to give them advices how to get better information.

In my message is all the information Phoon needed. Because he had got it
already.

For others who are searching for that I told in the message that it is in
the newsgroup languages.vb given by Ken (Tucker).

Read my complete message not only the start.

Cor

"clintonG" <cs*********@REMOVETHISTEXTmetromilwaukee.com> schreef in bericht
news:ep*************@TK2MSFTNGP12.phx.gbl...

If you were a DocType you would be strict :-) Give the guy a break Cor.
The best part about .general is asking general questions so the ignorati
who do not know which specific question to ask can be answered directly or
the OP can be directed to another resource if the person trying to reply
does have a specific answer.

It also seems that people who cross-post are ready to sh!t their pants if
they can't learn how to do something their brain just refuses to even
think about anymore. They make medicine for that.

So I would recommend variants of this type of search...

search: rounding site:msdn.microsoft.com
search: math class site:msdn.microsoft.com

Might as well do

search: truncation site:msdn.microsoft.com

Finally I would try...

search: brain dead and lazy site:Phoon Chee Keong :-)

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/



"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:eq**************@TK2MSFTNGP10.phx.gbl...

Phoon,

Please try to avoid multiposting. Although this is not such a relevant
post to this newsgroup can you by relevant subjects better use
crossposting (sending one message to more newsgroups).

Relevant is as well if you don't know which one.

For others this is answered by Ken in the language.vb newsgroup and
replied by Phoon that it was the needed answer.

Cor
"Phoon Chee Keong" <da******@streamyx.com> schreef in bericht
news:ut****************@TK2MSFTNGP10.phx.gbl...

Is that a formula in vb.net like Ms Excel? Currently my Excel formula is
"=(((ROUNDUP(I30/3000,0)+1)*G30)/1000)+((ROUNDUP(G30/10000,0))*I30/1000)",
but in vb.net how to write.

Any idea?
Regards,
PCK

[clintonG]

<snip />

For others who are searching for that I told in the message that it is in
the newsgroup languages.vb given by Ken (Tucker).

Read my complete message not only the start.

Cor

<snip />

I try to avoid going to news://microsoft.public.dotnet.languages.vb becuase
it makes me get itchy all over and then I need to take some medicine. ;-)

<%= Clinton Gallagher