Howdy. I have a spreadsheet of prices that need to be rounded to the nearest nickel. I have the formula:
Where A1 = 21.95
The result is 14.5 which is correct, but I'd like to have zero on the end because it is a currency. Is there a way to do this. If so can you provide the correct function. I found a similar problem in the forums, but it didn't look resolved.