S
Stephen P Thomas
I wish to test if the results of a calculation is an integer. An unknown
function perhaps in the stats package?
function perhaps in the stats package?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DerbyJim1978
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
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
B
Bob Phillips
=IF(INT(formula_result)=formula_result,"Integer","")
S
Shaz
=IF(MOD(B8,INT(B8))=0,"integer","not integer")
hope this helps.
hope this helps.
S
Shaz
=IF(MOD(B8,INT(B8))=0,"integer","not integer")