Hello...
I have a formula I am looking for some assistance with. The formula I
currently have rounds a dollar amount to the nearest dollar. The problem is
that it always rounds up. I need the formula to be able to determine, if
possible, wether it should round up or down.

Example: 33.49 should round down to 33.00....33.50 (and above) should round
up to 34.00.

Here is what I have (which may be completly wrong anyways but works as far
as rounding up only):

=IF(J6="X", CEILING(I26/I25,1), I26/I25)

Any assistance will be greatly appreciated. I thank you in advance for your
time!

--
Randy Street
Rancho Cucamonga, CA