hi all,

if i have a number in a cell (say 2.456) and i want to work with ONLY the
0.456 - is there a function that will let me do that

i can write a function in vba to take care of everything - i would prefery
to stay with worksheet functions as much as possible.

basically i am working with dollars and cents - and i want to create a
conditional function that will adjust the prices according to
$X.00 -> $(X-1).99
$X.01 - $X.24 -> $X.25
$X.25 - $X.49 -> $X.50
$X.50 - $X.99 -> $X.99

thanks for your help!

J