how do I test for Integer?:check out ROUND

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?

=IF(INT(formula_result)=formula_result,"Integer","")

--
HTH

Bob Phillips

"Stephen P Thomas" <Stephen P Thomas@discussions.microsoft.com> wrote in
message news:264C81F6-130E-4C94-A174-5C0ACA17A9DC@microsoft.com...
> I wish to test if the results of a calculation is an integer. An unknown
> function perhaps in the stats package?

=IF(MOD(B8,INT(B8))=0,"integer","not integer")

hope this helps.

=IF(MOD(B8,INT(B8))=0,"integer","not integer")

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

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?

=IF(INT(formula_result)=formula_result,"Integer","")

--
HTH

Bob Phillips

"Stephen P Thomas" <Stephen P Thomas@discussions.microsoft.com> wrote in
message news:264C81F6-130E-4C94-A174-5C0ACA17A9DC@microsoft.com...
> I wish to test if the results of a calculation is an integer. An unknown
> function perhaps in the stats package?

=IF(MOD(B8,INT(B8))=0,"integer","not integer")

hope this helps.

=IF(MOD(B8,INT(B8))=0,"integer","not integer")