Announcement

Collapse
No announcement yet.

Check if number is an Integer

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Check if number is an Integer



    I know there is an ISODD and ISEVEN and other IS functions but I haven't found an easy way to write a formula that evaluates whether the number is an integer or not. If anyone knows a simple way, please let me know. Thanks!

    Steve

  • #2
    This should work, with the number to be tested in A1

    =INT(A1)=A1
    Boo!

    Comment


    • #3
      need to test for true false

      The thing is that if it is an integer, then one set of instructions should be followed, if it is not an integer, then a different set of instructions should be followed. So I need a way of evaluating a number as an integer and returning true or false.

      Comment


      • #4


        nm

        Nevermind, I should have tried that before replying. It works. Thanks!!

        Comment

        Working...
        X