Hello,
In Excel, I want to find the formula to round a number (in a cell) up
to the nearest 5 denominator. I would also like another formula to
round a number (in a cell)down to the nearest 5 denominator. What are
the 2 formula to do this, please?

---

Request for Question Clarification by livioflores-ga on 28 Apr 2005 00:25 PDT

Could you give as an example of what are you want (it is not clear for
me what "nearest 5 denominator" means)?

Thank you.

---

Clarification of Question by bremar-ga on 28 Apr 2005 02:10 PDT

Thankyou,

I have a column A in Excel, which has numbers in it:
I want a formula to round the number down to the closest 5 denominator.

COL A       Round down to nearest 5 denominator: 
72.26       70
86.17       85
19.78       15 

Also after a formula to round up:

COL A       Round up to nearest 5 denominator 
70.26       75
86.17       90
19.78       20 

Thanks

Round up:
=CEILING(ref,5)

Round down:
=FLOOR(ref,5)

where ref is a number or cell reference.

Thankyou for the quick and accurate service, will use you again!

I like =mround(a1,5)
But it requires that the Analysis Toolpak be turned on.

Bremar is really going to like this service when he finds out that he
isn't being charged the $11.

Thanks for all your comments!
I don't understand why I am not being charged, as 
it has saved me time searching for the answers myself????
Cheers
Brett
Australia

It's a side-effect of Giggle's system.  Only ordained researchers can
get paid.  Those in the "peanut gallery" do it for... ummmm ... there
was a reason....

Google CC:

I recently used your Google Answers service 
and found it very quick, accurate and I will use it again!
I don't understand why I am not being charged, as 
it has saved me time, searching for the answers myself?
And more importantly someone took their time, to answer so I think 
they should be paid?
Anyway, not a complaint just feedback.
Cheers
Brett
Australia

Excel is one of those areas where there are people like me who know
excel well and can answer most most questions.  It is hard to compete
against excel people.  Excel power users are like a cult.  They enjoy
answering questions/  Bragging rights.

Thanks again for your time.
While I have you experts, I will ask
a question about matching data in Excel.
Say COL A has a list of data, which has corresponding data
in COL B.
Now what I want to do is enter in new data into COL C
and place a formula in COL D
which will do the following:
When data in COL A = data in COL C
show COL B data in COL D (Confused yet?)
COL A       COL B             COL C       COL D
sbl         6/25/05            msft        8/21/05
msft        6/19/05            sbl         6/25/05
ibm         6/2/05
msft        8/21/05
cat         10/25/05

Thanks in advance!

In col D have formulae like:
=VLOOKUP(C1,A1:B10,2)