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
|