Ending in 5 or 0

  • Thread starter Thread starter Scates
  • Start date Start date
S

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.
 
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
 
Back
Top