Help with formula

R

Randy

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!
 
D

Dave O

Hi, Randy-
The CEILING function specifically rounds up. Try ROUND instead, comme
ca:

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

ROUND rounds up or down at the .5 mark

Dave O
 
P

PCLIVE

I think you want ROUND, not CEILING.

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

HTH,
Paul
 
N

Nick Hodge

R

Randy

Added another ")" after the "0" and it worked like a charm!

Thank you very much for your quick response! You are a Rock Star!
--
Randy Street
Rancho Cucamonga, CA


Nick Hodge said:
Randy

Try

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round formula 1
Rounding up or down to nearest whole number 1
Rounding dollar amounts to the 9 cents 0
Format cell to the nearest 100 4
Round Down to the nearest multiple 3
rounding up to nearest specified whole number 1
Formula Help 2
Combine Formulas 3

Top