1研究者強 Int Number Value 第一
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 5730 articles for 8.221 sec
"Gonzalo " <glpita@gmail.com> wrote in message <hu26a0$hpf$1@fred.mathworks.com>... > Mr Stafford, > > Yes, I need f(x) to be the pdf for my generated random variable. Now, maybe I'm confused here, but I don't have that freedom to set p4=p5. Those coefficients come from a nonlinear regression of data, and f(x) fits the data very well. Regarding p1, it is approx equal to = 1/(2*(p3-p2)) * 100. Here     

Group: comp.softsys.matlab · Group Profile · Search for 1研究者強 Int Number Value 第一 in comp.softsys.matlab
Author: Roger Stafford
Date: Jun 1, 2010 02:27

Well, since an integer field cannot contain any number but a whole number (no decimal portion) and percentages are fractional (they have a decimal) there is no way to store percentages in an integer field. Format changes how the value is displayed and has nothing to do with how the information is stored. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University
Show full article (2.75Kb) · Show article thread
"John... Visio MVP" <lancucki@stonehenge.ca> wrote in message news:AFD49337-143A-4448-9B80-D8D8621F8784@microsoft.com... > "Help Visio!" <HelpVisio@discussions.microsoft.com> wrote in message > news:F5E15D05-529C-4BE0-B385-C9D9E9CB6D07@microsoft.com... >>I have set up a field, data type number, format= percent, but when I enter >> the number 5, it comes up as 500%% in the field on the table     

Group: microsoft.public.access.gettingstarted · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.access.gettingstarted
Author: John Spencer
Date: Aug 26, 2008 09:27

Why can't you? Because Access isn't Excel. How can you? Well, a brief Google turned this up: Public Function FormatSigFig(Value As Double, SigFigs As Long) As String Dim RoundedValue As Double Dim Digits As Long Digits = SigFigs - Int(Log(Abs(Value)) / Log(10)) - 1 FormatSigFig = Int(0.5 + Value * 10 ^ Digits) / 10 ^ Digits End Function Seems
Show full article (1.48Kb) · Show article thread
Bob, The requirement is generate (randomly) up 7 values between 101 - 110 in a row. No value can be repeated in the row. Therefore: 101 109 109 110 104 101 103 : is not working for me as you can see in this row 2 values were repeated. The formula would then be used to generate values between the same criteria in following rows : up to 100 rows where repeated values from the row above     

Group: microsoft.public.access.gettingstarted · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.access.gettingstarted
Author: John... Visio MVP
Date: Aug 26, 2008 09:12

I am not understanding. IN your original post you said that you would have one number between 101 and 110, and you want another that was not equal to. Where do the 7 numbers in a line now come into it? What exactly is the requirement? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jackanorry" <Jackanorry@discussions.microsoft.com> wrote
Show full article (0.99Kb) · Show article thread
Darn, I got a little ahead of myself. While the formulae do work, there's a 'glitch' of sorts in that on each line (consists of up to 7 numbers) there is atleast one number that is repeated - see below. 101 109 109 110 104 101 103 Here's the formula Bob provided =IF(($A$1="")+(AND(B2>0,COUNTIF($B$1:$B2,B2)=1)),B2,INT(RANDBETWEEN(101,110))) Thanks again John "Bob Phillips" wrote     

Group: microsoft.public.access.reports · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.access.reports
Author: bcap
Date: Aug 8, 2008 01:12

Bob & joeu2004 -- thanks for your responses. Both worked - great stuff. Thanks again John "Bob Phillips" wrote: First, ensure cell A1 is empty and goto Options and on the Calculation tab check the Iteration checkbox to stop the Circular Reference message. Next, type this formula into cell B1 =IF(($A$1="")+(AND(B2>0,COUNTIF($B$1:$B2,B2)=1)),B2,INT(RANDBETWEEN(101
Show full article (1.25Kb) · Show article thread
First, ensure cell A1 is empty and goto Tools>Options and on the Calculation tab check the Iteration checkbox to stop the Circular Reference message. Next, type this formula into cell B1 =IF(($A$1="")+(AND(B2>0,COUNTIF($B$1:$B2,B2)=1)),B2,INT(RANDBETWEEN(101,110))) it should show a 0. Finally, put some value in A1, say an 'x', and all the random numbers will be generated, and they won't     

Group: microsoft.public.excel.misc · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.excel.misc
Author: Jackanorry
Date: Jul 9, 2008 06:27

Thanks Uli, for an illuminating extension of my awareness of available functions. And Touché! When one uses a shortcut at the beginning to simploify formulae, one should account for it at the end. I totally forgot the need to drop that last payment. I started with the understanding that interest was accumulating, so I wanted the final period, but missed even then on the need to eliminate
Show full article (2.54Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.excel.misc
Author: Bob Phillips
Date: Jul 7, 2008 00:55

Show full article (1.87Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.excel.misc
Author: Jackanorry
Date: Jul 6, 2008 18:23

Show full article (1.34Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.excel.misc
Author: Jackanorry
Date: Jul 6, 2008 14:19

Show full article (1.06Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for 1研究者強 Int Number Value 第一 in microsoft.public.excel.misc
Author: Bob Phillips
Date: Jul 3, 2008 00:38

Show full article (0.87Kb) · Show article thread
    

Group: corel.QuattroPro12 · Group Profile · Search for 1研究者強 Int Number Value 第一 in corel.QuattroPro12
Author: Don Codling
Date: May 30, 2008 05:51

Show full article (8.24Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next