I am working in file where I want my prices to either end in .%9 or .%5. I put the "%" because they can be any number. For example, I have a price of 68.55 and want to keep that the same since it ends in 5. I have another price of 61.47 and want that price to end in .49( it would be 61.49). I have used the round function but don't know how to let Excel know to keep ones ending in 5 as the same.
I've changed all numbers to end in 9 but not keep it to end in 5. Let me know