Bob -
How can I round all of the cells in that column without creating a
circular reference? I don't want to add a column for the rounded
percentages, just want to round them all to the percent. =ROUND(C3,2)
creates a circular reference obviously if I would paste it in C3. Any
suggestions? Thanks,
Steve


Bob Phillips wrote:
=ROUND(C3,2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nemadrias" wrote in message
ups.com...
Thanks! I'm almost positive you hit it on the head there with the
rounding. For example, cell C3 is actually 15.2, but as a percentage
it shows up as 15% in the cell. When I apply the round to the cell
=ROUND(C3,0) it rounds .152 to 0. What I want is for it to round it to
15%. Do you know how to do this? Thanks so much,
Steve



daddylonglegs wrote:
If your conditional formatting doesn't give the correct result when C12
and F12 are equal that's probably because the aren't EXACTLY equal.
e.g. if you only display without decimals then 16% could in reality be
16.23%. You could use conditional formatting formulas like

=ROUND(C12,0)Round(F12,0)

=ROUND(C12,0)<Round(F12,0)

=ROUND(C12,0)=Round(F12,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=565769