In cell A2 is the number 78.13. I am trying to write a formula that rounds A2 down if the last digits is between 0 and 5 and round up if the last is between 6 and 9. This formulas does round down if the number is less than 5 but it will not round up when the number is 5 or greater.
=IF(AND(RIGHT(A2)<5,RIGHT(A2)>0),ROUNDDOWN(A2,0),ROUNDUP(A2,0))
=IF(AND(RIGHT(A2)<5,RIGHT(A2)>0),ROUNDDOWN(A2,0),ROUNDUP(A2,0))