tri this =round(a1,-3)
On Mon, Jul 4, 2011 at 9:31 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Anshul, > > As per the latest scenario provided by you, attached solution may help you. > Let me know if this works :) > > Regards, > DILIPandey > > On 7/4/11, Anshul Gupta <thatsme.a...@gmail.com> wrote: > > Hi All > > > > No boss this is also not working see i show you what excatly i want > > > > 202.718 > > 198.724 > > 200.178 > > 202.867 > > 195.514 > > Total 1000.000 > > > > this is i want that random unique numbers between 195.001 to 203.999 > which > > always gives a total of 1000.000 after every total of 5 numbers > > > > Help me guyssssssssssssssssssssssssssssssss > > > > cheers!!! > > On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma > > <rajanverma1...@gmail.com>wrote: > > > >> *See if it help* > >> > >> http://www.mrexcel.com/tip069.shtml**** > >> > >> ** ** > >> > >> * * > >> > >> * * > >> > >> *From:* excel-macros@googlegroups.com [mailto: > >> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy > >> *Sent:* Saturday, July 02, 2011 9:29 PM > >> > >> *To:* excel-macros@googlegroups.com > >> *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!**** > >> > >> ** ** > >> > >> Sir, > >> Do u have any idea of auto filling magic squre for a particular sum > >> total. Iam interested > >> to know it. Thanks if u could help. > >> -R.Karunanithi > >> > >> --- On *Sat, 7/2/11, Rajan_Verma <rajanverma1...@gmail.com>* wrote:**** > >> > >> > >> From: Rajan_Verma <rajanverma1...@gmail.com> > >> Subject: RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!! > >> To: excel-macros@googlegroups.com > >> Date: Saturday, July 2, 2011, 8:25 PM**** > >> > >> *See if it helps***** > >> > >> * ***** > >> > >> *From:* excel-macros@googlegroups.com [mailto: > >> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta > >> *Sent:* Saturday, July 02, 2011 7:39 PM > >> *To:* excel-macros@googlegroups.com > >> *Subject:* $$Excel-Macros$$ Urgent Help required!!!!!!!!!!**** > >> > >> **** > >> > >> Hi All. > >> > >> As m working in a import house for that i have to sales bills on daily > >> basis i just want a help that makes me easy to make that > >> > >> If someone tell that how to make 5 random numbers selection between > >> 197.001 > >> to 203.999 which gives the total of 1000.000 > >> > >> Please help meurgent guys > >> > >> Cheers!!!! **** > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel**** > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel**** > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel**** > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > >> > > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel