View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Candyk
 
Posts: n/a
Default rounding to 25 cent incriments

Thank You! Thank You! Thank You!
I will go back to my humble little workbook now....
ever so happy you showed me how to do what I wanted it to do.
Thank you again!
Candice

"Ron Coderre" wrote:

Try this:

For a value in A1

B1: =CEILING(A1,0.25)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP


"Candyk" wrote:

Hi and help please,
I need to round a dollar value up to the nearest .25 cents.
I want to do this is botha: cells that I enter a dollar value into
and cells that display the result of a sum (formula)
Please tell me how to do it.
Thanks,
Candice