Round up Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Richard said:
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.
Click to expand...

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?
 
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,
 
Back
Top