I may not be asking this correctly, But let me try to explain what I need help with.
I am creating a spreadsheet for being able to quote a price to customers. I am looking for a formula to automatically round the sum of several numbers to the next .05 increment.
For example: My product costs $10.35, my freight costs $4.71 my commission is .35 cents my total cost is $15.41 cents.
I would like to take the sum of those 3 numbers, and round it to the next .05 increment. in this case $15.45
I have a separate sheet, that I have linked the results of the equation, that I am using for my quote sheet, and do not want to have to go change the answers manually, but to have it automatically completed.
I am currently using the formula below, bit will only round up to the next .10 interval. And if I change the 1 to a 2, it does not round up, it gives me exact price.
=ROUNDUP(SUM(B3+D3+E3),1)
So in other words.. HELLLPPPPPPPPPPPP
Sincerely,
Somebody who does not know what the are doing.
Bookmarks