in F1 type:

=ROUND(E1,0)-E1

Alternatively, if you always want to round up and never down, in F1 type:

=ROUND(E1+0.49,0)-E1

Regards,

"Richard" wrote:

If cell E1 has, lets say $1.75 in it. Is there a way to leave E1 as it is
$1.75, BUT round it up to the nearest dollar and put the difference only .25
in cell F1.