show <0.01%?

D

Doreen

Excel 2002

I have a user that is showing percentages...and if the percent is .00005%,
and we're only showing 2 decimal points, he wants it to say <0.01%, instead
of 0.0%.

Is there an easy way to have Excel show this? Or is this a manual edit we
need to do?

Thanks!
 
T

Trevor Shuttleworth

Doreen

if you onlly want to view the result, you could try a formula such as:

=IF(A1<0.01%,"<0.01%", A1)

But this might not work if you want to be able to add the results

Regards

Trevor
 
D

Doreen

I do just want to be able to view it, thanks!
Trevor Shuttleworth said:
Doreen

if you onlly want to view the result, you could try a formula such as:

=IF(A1<0.01%,"<0.01%", A1)

But this might not work if you want to be able to add the results

Regards

Trevor
Click to expand...
 
D

Debra Dalgleish

You can also do this with formatting:

Select the cells
Choose Format>Cells
Select the Number tab
Select the Custom category
In the text box, type: [<0.0001]<0.01%;0.00%
Click OK
 
Top