Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
=IF(INT(formula_result)=formula_result,"Integer"," ")
-- HTH Bob Phillips "Stephen P Thomas" <Stephen P wrote in message ... I wish to test if the results of a calculation is an integer. An unknown function perhaps in the stats package? |
#4
|
|||
|
|||
=IF(MOD(B8,INT(B8))=0,"integer","not integer")
hope this helps. |
#5
|
|||
|
|||
=IF(MOD(B8,INT(B8))=0,"integer","not integer")
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistic: Problem with two one sided t-test | Excel Discussion (Misc queries) | |||
Excel competency test | Excel Discussion (Misc queries) | |||
=IF logical test to search only part of a cell | Excel Worksheet Functions | |||
test..where are my messages..test | New Users to Excel | |||
Test for Single Character That is in an Array | Excel Worksheet Functions |