Good day to all!
I was trying to use the ROUNDUP function in excel but it seems limited to a specific number that you have to use.
I have a spread sheet with a price list and I want to roundup every price so it is a nice sales number like $0.95.
I have tried everthing I can think of but can't get it to round up the decimal places to .95 without going through each one by hand. I have over 800 products to do this with all of course can range from 1 dollar to 200 dollars.
Some help on this would be much appreciated.
I was trying to use the ROUNDUP function in excel but it seems limited to a specific number that you have to use.
I have a spread sheet with a price list and I want to roundup every price so it is a nice sales number like $0.95.
I have tried everthing I can think of but can't get it to round up the decimal places to .95 without going through each one by hand. I have over 800 products to do this with all of course can range from 1 dollar to 200 dollars.
Some help on this would be much appreciated.