# Thread: If conditions Thanks: 0 Likes: 0

1. ## 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.

zarir

2. ## 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. ## Re: If conditions

=INT(A1)

will give you just the integer part

4. ## Re: If conditions

thanks a ton mate

## User Tag List

#### Posting Permissions

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