+ Reply to Thread
Results 1 to 2 of 2

formula using Divisibility test

  1. #1
    kspeedy28
    Guest

    formula using Divisibility test

    I am trying to use a divisibility test in a formula to determine if the
    answer comes out as a whole number or not.

  2. #2
    Nigel
    Guest

    Re: formula using Divisibility test

    use the Modulus function that returns zero for the 'whole' number test you
    require e.g..........

    =IF(MOD(A1,B1)>0,"Non Divisible","Divisible")

    --
    Cheers
    Nigel



    "kspeedy28" <kspeedy28@discussions.microsoft.com> wrote in message
    news:159BAD75-1D7D-48D5-8CA3-1754C300DB8C@microsoft.com...
    > I am trying to use a divisibility test in a formula to determine if the
    > answer comes out as a whole number or not.




+ 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