+ Reply to Thread
Results 1 to 3 of 3

Cell can only equal Whole Number

  1. #1
    TriFiV
    Guest

    Cell can only equal Whole Number

    I need set up a formula so that if the answer is not a whole number, an error
    message will show. Thank you.

  2. #2
    Gary''s Student
    Guest

    RE: Cell can only equal Whole Number

    Let's say we are interested in =A1/A2 being an integer, use:

    =IF(INT(A1/A2)*A2=A1,A1/A2,"ERROR")

    so if A1 is 12 and A2 is 6 you will see 2
    if A1 is 13 and A2 is 6 you will see ERROR


    The general form is :
    =IF(INT(A1)=A1,A1,"ERROR")
    --
    Gary's Student


    "TriFiV" wrote:

    > I need set up a formula so that if the answer is not a whole number, an error
    > message will show. Thank you.


  3. #3
    David Biddulph
    Guest

    Re: Cell can only equal Whole Number

    "TriFiV" <[email protected]> wrote in message
    news:[email protected]...
    >I need set up a formula so that if the answer is not a whole number, an
    >error
    > message will show. Thank you.


    =IF(MOD(your formula,1)=0,your formula, "Error")
    --
    David Biddulph



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1