ROUNDING DOWN IN INCREMENTS OF 5 1

[Robbo1971]

How do I round down a number in an increment of 5?

Example:

if I have an aswser of £6.52... how do I round down to £5.00

or

if I have a answer of £21.06... how do I round down to £20.00

I only want to use £5, £10, £15, £20 etc. etc.

I am trying to create a spreadsheet for use when bidding at an auction.

 

[Onda]

You could try this:
=INT(A1/5)*5
A1 is the cell that you wont to round.

Onda

 

[etarhan]

Assuming that the value you want to round down to a multiple of 5 is located in cell A1:

floor(A1;5)

the field separator ( may be different for your country

Good luck,
Engin

 

[asixth]

Again, looks like you already have an answer posted but I use the following:

=ROUNDDOWN(A1/5,0)*5

Where A1 is the cell that contains the data.

 

[WhiteyWhitey]

Or for another

= A1 - MOD(A1,5)

 

[GRoberts]

One way I did it that will round up or down to the nearest 10 or 5 is as follows"

=IF(ABS(A1-((ROUND(A1,-1)+5)))>5,ROUND(A1,-1),(ROUND((A1*2),-1)/2)+5)