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

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.

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

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?

--
Regards,
Dave


"dd" wrote:

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.