Round up Formula Help
 

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.

Round up Formula Help
 

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.

I think you want:

F1: =roundup(E1,0) - E1

Note that I am interpreting you literally when you say "round up". The
formula above will put $0.99 into F1 if E1 is $1.01. Is that what you
want?

Round up Formula Help
 

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.

Round up Formula Help
 

F1 =CEILING(E1,1)-E1

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