eeeek

Take the first ( off, sorry

=IF(J6="X", ROUND(I26/I25,0), I26/I25)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Nick Hodge" wrote in message
...
Randy

Try

=IF(J6="X", (ROUND(I26/I25,0), I26/I25)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/


"Randy" wrote in message
...
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