Can I turn off roundup automatically for a cell?

  • Thread starter Thread starter Rob B
  • Start date Start date
R

Rob B

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
 
You must log in or register to reply here.

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

Roundup Nesting 13
Number rounding within a formula 2
Find and Replace ROUNDUP(stuff, 0) 3
Count Unique With one Condition & No ROUNDUP 7
Excel Custom Function with Select Case 14
A non roundup decimal place cell format 6
How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi 2
Roundup Function 5

Back
Top