I have a column of prices, and want to round them down to the nearest lower $, however when I use ROUNDDOWN, if the price is already at 0c eg $164.00, it rounds it down to the next lowest integer (in this example $163). What formula can I wrap around my ROUNDDOWN so it leaves the number alone if it is already a whole number?
Bookmarks