rounding to the nearest 100

  • Thread starter Thread starter Guest
  • Start date Start date
I neglected to say i will be grateful for the code for both negative numbers
and positive numbers, i have used the floor or ceiling function to date on
positives but does not appear to work on negatives
 
Hi Spike,

Why not just use the Round() function? If in VBA, you can access it from
Application.Worksheetfunctions.

HTH
 
Thanks, i think i tried this initially, anyway using floor getting what is
required
--
with kind regards

Spike


Zack Barresse said:
Hi Spike,

Why not just use the Round() function? If in VBA, you can access it from
Application.Worksheetfunctions.

HTH
Click to expand...
 

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

rounding to nearest .5 in vba 12
Round to Nearest 25 Percent? 1
Round number subject to it's value 1
Calculating parts costs rounded to the nearest $15 in Excell 1
Format cell to the nearest 100 4
How do I round to the nearest 25 cents in Excel? 2
round to nearest 30-minute interval 2
Round to nearest whole number 5

Back
Top