If conditions
Results 1 to 4 of 4

Thread: If conditions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2003
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default If conditions

    hi guys,

    i guess this is a very basic question for u guys but i just cant seem to get this working.

    i have a few values in column A. they are all positive values ranging from anywhere between 0 to 999. all these numbers would have decimal places.

    In column B, i need to retrieve just the main integer and not the decimal point.

    Eg.

    Column A Column B

    6.58 6
    12.25 12
    158.76 158

    I know this'll work with the IF and LEFT function and tried using it but i guess i'm doing something wrong as i just cant get the desired output.

    Would appreciate any kinda help.

    Thanks in advance.
    zarir

  2. #2
    New Member
    Join Date
    Aug 2003
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If conditions

    sorry guys but the example has not come out too clearly so redoing that part.

    6.58 in column A must show me 6 in column B
    12.25 in column A must show me 12 in column B
    158.76 in column A must show me 158 in column B

    cheers
    zarir

  3. #3
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,638
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If conditions

    =INT(A1)

    will give you just the integer part
    "Fair Winds and Following Seas"

  4. #4
    New Member
    Join Date
    Aug 2003
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If conditions

    thanks a ton mate

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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