I am trying to round up a number for work I am not sure if I have the wrong code. This is the code I have =ROUNDUP(D4, 1). I want to make 35.73 35.75. Do I have the wrong code? TIA
bonitachyc
Posted:
Member since
Re: Excel help PLEASE!
why don't you just change the formatting of the cells to two decimal places?
If you do roundup, I don't think it rounds up to 35.75, it will roundup to 35.8.
Jaysgirl119
Posted:
Member since
Re: Excel help PLEASE!
ahh that is why it does not work Thank you I feel a better now.
bonitachyc
Posted:
Member since
Re: Excel help PLEASE!
ooooooh gotcha!
snwb08
Posted:
Member since
Re: Excel help PLEASE!
you probably figured this out already but when you want to round to a certain number like you are doing you need to use mround, not roundup. So if you do =MROUND(cell,0.05) that will round it to the nearest .05 cents. HTH
Jaysgirl119
Posted:
Member since
Re: Excel help PLEASE!
Thank you I found this formal: =CEILING(D16,0.05) not sure if its the same thing but it work woohooo lol
snwb08
Posted:
Member since
Re: Excel help PLEASE!
Posted by Jaysgirl119
Thank you I found this formal: =CEILING(D16,0.05) not sure if its the same thing but it work woohooo lol
