Can I turn off roundup automatically for a cell?
 

Hello,

Does anyone know if there is a way to display 99% in a cell (if that
is the calculated output based on a formula) if I am limiting the
number to 0 decimals and the real output is 99.95%? Currently, it
show 100% if I limit the cell to no decimals. Basically, I would
rather it say 99% and turn off the roundup.

Thanks

Can I turn off roundup automatically for a cell?
 

=ROUNDDOWN(your_formula,2)

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

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



"Rob B" wrote in message
m...
Hello,

Does anyone know if there is a way to display 99% in a cell (if that
is the calculated output based on a formula) if I am limiting the
number to 0 decimals and the real output is 99.95%? Currently, it
show 100% if I limit the cell to no decimals. Basically, I would
rather it say 99% and turn off the roundup.

Thanks


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004