Results 1 to 3 of 3

Thread: Excel

  1. 29-11-2009, 02:10 PM #1
    Will404
    Will404 is offline
    Senior Member
    Join Date
    May 2008
    Location
    Bath Uni
    Posts
    1,140
    Thanks
    169
    Thanked
    71 times in 66 posts
    • Will404's system
      • Motherboard:
      • ASUS P5Q PRO
      • CPU:
      • Core2quad Q6600 @2.85GHz
      • Memory:
      • 4GB Corsoar Twin X XMS2 DDR2-PC2 6400 @ 900MHz, 5-5-5-18
      • Storage:
      • WD 320GB, Segate 320GB (Raid 0), 2* WD 1TB storage
      • Graphics card(s):
      • ATI Sapphire HD 4850
      • PSU:
      • Corsoar HX 520
      • Case:
      • Antec 900
      • Operating System:
      • Windows 7 Pro x64
      • Monitor(s):
      • ASUS MW221u 22"

    Excel

    Is there a formula which will search select cells for integers (using excel 2007)??

    thx in advanced
    Reply With Quote Reply With Quote
  2. 29-11-2009, 04:18 PM #2
    Will404
    Will404 is offline
    Senior Member
    Join Date
    May 2008
    Location
    Bath Uni
    Posts
    1,140
    Thanks
    169
    Thanked
    71 times in 66 posts
    • Will404's system
      • Motherboard:
      • ASUS P5Q PRO
      • CPU:
      • Core2quad Q6600 @2.85GHz
      • Memory:
      • 4GB Corsoar Twin X XMS2 DDR2-PC2 6400 @ 900MHz, 5-5-5-18
      • Storage:
      • WD 320GB, Segate 320GB (Raid 0), 2* WD 1TB storage
      • Graphics card(s):
      • ATI Sapphire HD 4850
      • PSU:
      • Corsoar HX 520
      • Case:
      • Antec 900
      • Operating System:
      • Windows 7 Pro x64
      • Monitor(s):
      • ASUS MW221u 22"

    Re: Excel

    OK, I got it so no more need:

    IF any of the millions who relpied to this were wondering:

    =INT(cell)=cell
    Reply With Quote Reply With Quote
  3. 29-11-2009, 04:19 PM #3
    PeteSmith
    PeteSmith is offline
    Master Browser PeteSmith's Avatar
    Join Date
    Aug 2004
    Location
    LV-426
    Posts
    661
    Thanks
    44
    Thanked
    45 times in 42 posts
    • PeteSmith's system
      • Motherboard:
      • ABIT IP35 Pro
      • CPU:
      • Q6600 G0
      • Memory:
      • 4x1GB 8500 Crucial Ballistix
      • Storage:
      • System: Crucial 128GB M4 SSD Storage: 2x500GB WD5000AAKS
      • Graphics card(s):
      • GTX 650
      • PSU:
      • Corsair HX 620
      • Case:
      • Antec P182
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Dell 2407WFP-HC

    Re: Excel

    =IF(ISNUMBER(A1),IF(MOD(A1,INT(A1))=0,TRUE,FALSE))

    Taken from MrExcel. You can use a named range in place of the direct cell reference.
    Main PC : Abit IP35-Pro | Q6600 G0 @ 3GHz | 4x1GB Crucial Ballistix 8500 | MSI N460 GTX HAWX | 1 x Crucial M4 128GB SSD | Antec 182 | Corsair HX620 | Dell 2407WFP-HC | Windows 10 x64
    Server : HP MicroServer N40L | 16 GB RAM | 4 X 1 GB Samsung Spinpoint F1 | ESXi 6.0 NAS : Synology DS-408 - 4 x 3GB WD RED HTPC : Acer Revo RL70 | LibreElec
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Vlookup not working (sort of)
    By piggeh in forum Help! Quick Relief From Tech Headaches
    Replies: 9
    Last Post: 03-09-2010, 04:35 PM
  2. .NET Reading Multiple Excel Files
    By Shadow_101 in forum Software
    Replies: 5
    Last Post: 23-11-2007, 03:22 PM
  3. Excel + Database + Automated
    By Kezzer in forum Software
    Replies: 4
    Last Post: 29-03-2007, 04:54 PM
  4. Excel windows
    By Steve in forum Software
    Replies: 4
    Last Post: 25-07-2006, 12:44 PM
  5. IE Opens Excel Spreadsheet In Web, Not Excel
    By Vini in forum Software
    Replies: 6
    Last Post: 12-08-2005, 08:50 AM

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