about decimal in cell value

[Maileen]

Hi,

I have some values in some cells... something like 90.25, 102.78,...

i would like to do something like :

if (decimal value of cell >0.5) then value of cell = integer value of cell
+1
else if ((decimal value of cell >0.5) then value of cell = integer value of
cell
end if

ex :
for 102.78, the new value will be 103
for 90.25, the new value will be 90

but not in VBA...just using functions... but i don't know which are the 2
functions which could give me the integer part of value and just the decimal
value...

thanks a lot
Maileen

 

[Frank Kabel]

Hi
use
=ROUND(A1,0)