Ending in 5 or 0

[Scates]

Please help...I am working on a project (fees by month) and my boss
wants all the numbers to either end in 0 or 5...How can this be done.

 

[Peo Sjoblom]

One way

=ROUND(A1/5,0)*5


where A1 holds the number will round to the nearest 5

 

[Frank Kabel]

Hi

create a new helper column "B" and insert the following formula
(assuming that your numbers a stored in column A):
=MOD (A1;5)
and copy this formula for all rows

After this you can sort all rows with the result '0'. These are all
numbers ending with either '0' or '5'.

Frank