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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula 4
Formula to round up 4
Round-Up question 2
Rounding up 2
rounding up to nearest specified whole number 1
Rounding 4
creating nested formulas from drop down box 5
How can I Round up to the nearest .25 11

Back
Top