round up a 1999 + 1999 to the nerest 100 = 2000 + 2000

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

Guest

i want to round up a cell that has a fomular in it B1+B2 b1 is 1999 and b2 is
1999 the answer is 3998 but i want 4000
Thanks Keith
 
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

How to distribute/spread/map cost of project across different year 3
Look up within date range 2
IF formula 4
League age chart 4
Date 2
Macro to delete rows 3
If Statement - Date Calculations 3
If Statement - Date Calculations 1

Back
Top