×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

ROUNDING DOWN IN INCREMENTS OF 5

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.

RE: ROUNDING DOWN IN INCREMENTS OF 5

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

Onda

RE: ROUNDING DOWN IN INCREMENTS OF 5

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

RE: ROUNDING DOWN IN INCREMENTS OF 5

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.

RE: ROUNDING DOWN IN INCREMENTS OF 5

Or for another

= A1 - MOD(A1,5)

RE: ROUNDING DOWN IN INCREMENTS OF 5

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)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources