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!

This formula should do the trick:

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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>
>

Thanks!

"davegb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This formula should do the trick:
>
> =IF(A4<0.0001,"<0.01%",A4)
>

I do just want to be able to view it, thanks!
"Trevor Shuttleworth" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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!
> >
> >
>
>

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

Doreen wrote:
> 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!
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html