Checking for whole numbers in a worksheet

Discussion in 'Excel' started by qadude, Oct 20, 2011.

  1. qadude

    qadude

    Joined:
    Oct 20, 2011
    Messages:
    1
    Likes Received:
    0
    I have a worksheet nearly full of decimal and whole number values. I need to determine if a particular row contains whole numbers so the row can be deleted. Does anyone know how I can achieve this?
     
    qadude, Oct 20, 2011
    #1
    1. Advertisements

  2. qadude

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    (B3=7.5, e.g.), B3 - INT(B3) ===> 7.5 -7=.5 <=== any difference greater zero means you had a decimal number.
    B3=15.0 ===> 15.0 - 15=0 <===a difference of zero means you had a whole number. If you have a row where all the differences between the original number and its integer add up to zero, that row is all whole numbers and needs to be deleted.

    {=IF(SUM(A9:G9-INT(A9:G9))=0,"DELETE ROW","")}
    This is an array (CSE) formula and it WILL NOT WORK if you type the { and the }. Type everything but those (in cell H9, perhaps), then press Ctrl-Shift-Enter (hence the CSE).
     
    XLPadawan, Jun 14, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Maithem

    Arabic numbers

    Maithem, Feb 5, 2012, in forum: Excel
    Replies:
    0
    Views:
    463
    Maithem
    Feb 5, 2012
  2. Stormy4757
    Replies:
    1
    Views:
    692
    XLPadawan
    Jun 9, 2016
  3. Syed Baqar nazar

    Required Remittance Advice full Worksheet

    Syed Baqar nazar, Nov 27, 2015, in forum: Excel
    Replies:
    1
    Views:
    724
    XLPadawan
    Jun 14, 2016
Loading...