ROUNDUP Formula

  • Thread starter Thread starter Phoon Chee Keong
  • Start date Start date
P

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
 
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
 
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/
 
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
 
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
 
Back
Top