If conditions

[zarir]

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

 

[zarir]

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

 

[fairwinds]

=INT(A1)

will give you just the integer part

 

[zarir]

thanks a ton mate