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
 

You might want to check out the ROUND worksheet function.

If A1 contains 2.15
=ROUND(A1, 1) equals 2.2
If A1 contains 2.149
=ROUND(A1, 1) equals 2.1

or
=ROUND(-1.475, 2) equals -1.48
=ROUND(21.5, -1) equals 20

hth
Vaya con Dios,
Chuck, CABGx3



"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.