I am trying to multiple one cell by a set number and then I need to have the result rounded to the nearest tens. If the number ends with a 4 or less I need it to round to the lower tens. Example 8654, I need to have rounded to 8650. Also, if the number ends in a 5 or above I need it to round to the next highest tens. I have multiple rows to do this with so I was thinking of a if then statement but can't figure it out.
Ok that works except there is a rounding error during the multiplication process. Here's everything that I'm inputting, E3(cell with my number)*1.026,-1. The problem is that on some of the results it is being rounded down instead of up. I have one that I've found so far that when the cell is multiplied by the 1.026 only the result drops the decimals and gives me 37285but when I use the rounding formula in the equation it rounds the result to 37280 instead of 37290.