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