Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on Cell
A, but I can't seem to get the ROUND feature to work when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another
cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to
2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.