show <0.01%?

[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!

 

[davegb]

This formula should do the trick:

=IF(A4<0.0001,"<0.01%",A4)

 

[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

 

[Doreen]

Thanks!

 

[Doreen]

I do just want to be able to view it, thanks!

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

 

[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