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
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