In Excel, how do I look for the last number either 0 or 5

G

Guest

On our pricing sheet, we want to round up if the last number of a two decimal
place 5 or more and round down if less than 5 per cell. I know a if
statement should do it, but have not been able to complete one.
 
G

Guest

I think you should be able to do this with a simple ROUND() function...

=ROUND(A1,1)

For example, This will turn 45.85 into 45.90 and 45.84 into 45.80. Is this
what you wanted?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to round a number up or down 3
Calculate to the third decimal and round up or down in cell 6
How do I round last number without a decimal point 1
Round a number in nested function 1
Changing display of decimal value based on the value in the cell 3
How do I do this? 3
Rounding in Excel 2
Need help implementing EPA rounding method 17

Top