Results 1 to 4 of 4

Thread: *Resolved* Function to check for Integers?

Threaded View

  1. Dec 16th, 2004, 01:23 PM #1
    TheRobster
    TheRobster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    Resolved *Resolved* Function to check for Integers?

    Is there a worksheet function or formula that can check the result of a calculation to see if the result is an integer and, if so, perform an operation?

    I am trying to use an IF...AND formula but only want an action to be carried out if the result of one cell divided by another is an integer. This is the code:

    Code:
    =IF(AND(E59=TRUE,F58/H18=ISINTEGER),J18,0)
    The bit in bold (ISINTEGER) is the part I can't get to work, since there is no ISINTEGER function. But is there something similar which will actually work? I thought there might be functions such as: ISINTEGER, ISINT, ISWHOLENUMBER etc etc, but there appears to be nothing like this.

    Anyone got any ideas?
    Last edited by TheRobster; Dec 17th, 2004 at 09:06 AM. Reason: Resolved
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width