RE: how do I test for Integer?

Stephen,

I can't think of a formula that tests whether or not it is a integer however
I can supply another solution:

If A1 = the results of your calculation, let's say 0.5

Then in A2 write =int(A1), this will return the value 1

In A3 write = if(A1=A2,"Yes","No"). This will tell you whether or not your
original value was an integer or not.

You may also wish to check out ROUND (roundup/rounddown) and CEILING formulae.

Regards

Jim

"Stephen P Thomas" wrote:

> I wish to test if the results of a calculation is an integer. An unknown
> function perhaps in the stats package?
.

Relevant Pages

  • Re: how do I test for Integer?
    ... Bob Phillips ... > I wish to test if the results of a calculation is an integer. ... An unknown ... > function perhaps in the stats package? ...
    (microsoft.public.excel.worksheet.functions)
  • how do I test for Integer?
    ... I wish to test if the results of a calculation is an integer. ... An unknown ... function perhaps in the stats package? ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is this guy familiar with Sean Pitman?
    ... mathematical calculation shows that some routine process is impossible, ... You forget, John, that common descent isn't a "mechanism". ... What mechanism for ID are you proposing, Sean? ... How can I go about testing the, uh, hypothesis that "an unknown thing ...
    (talk.origins)
  • Re: Computation of AIC and AIC with weights
    ... In accordance with Venables and Ripley, SAS documentation and other ... Why the slight difference between my calculation in R and R's AIC? ... -joe yarmus ... represented by the constant + 2) and the unknown ...
    (sci.stat.math)
  • SUM or COUNT and adding a row
    ... same and the one row will be missing from the calculation. ... How could I resolve it and give the user the flexibility to add a row the ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)