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

Hi

This should work I guess

if A1 contains your value, den put this in any cell to get the rounded
value.

=IF(MOD(A1,0.25) = 1/8, CEILING(A1,0.25), FLOOR(A1,0.25))


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548291

Hi,

=ROUND(A1*4,0)/4

or

= ROUND(A1/25,2)*25

HTH,
Bernd

Thank you, now this is great, it rounds up but it also rounds down as
well...such as 256.36 becomes 256.25
can I make "any/all" rounds go "upwards"?


"KellTainer" wrote:


Hi

This should work I guess

if A1 contains your value, den put this in any cell to get the rounded
value.

=IF(MOD(A1,0.25) = 1/8, CEILING(A1,0.25), FLOOR(A1,0.25))


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548291

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

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

Np, yeah, I was assuming you meant a rounded function because it was
specifed up or down lol.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548291