ROUNDING DOWN IN INCREMENTS OF 5
ROUNDING DOWN IN INCREMENTS OF 5
(OP)
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.
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.





RE: ROUNDING DOWN IN INCREMENTS OF 5
=INT(A1/5)*5
A1 is the cell that you wont to round.
Onda
RE: ROUNDING DOWN IN INCREMENTS OF 5
floor(A1;5)
the field separator (;) may be different for your country
Good luck,
Engin
RE: ROUNDING DOWN IN INCREMENTS OF 5
=ROUNDDOWN(A1/5,0)*5
Where A1 is the cell that contains the data.
RE: ROUNDING DOWN IN INCREMENTS OF 5
= A1 - MOD(A1,5)
RE: ROUNDING DOWN IN INCREMENTS OF 5
=IF(ABS(A1-((ROUND(A1,-1)+5)))>5,ROUND(A1,-1),(ROUND((A1*2),-1)/2)+5)