formatting number in a text field

[mathew]

I'm sure this question will be a very easy one.
I need to add a calculated number to a text field in an If statement but
limit the number of decimal points.
I have =IF(E28>0,"road system is "&E28,"good Job")
Cell E 28 is a calculated percentage!
How do I show this number as just a % in this If Statement?

[Jim Thomlinson]

Try this...

=IF(E28>0,"road system is "& Text(E28, "0.0%") ,"good Job")
--
HTH...

Jim Thomlinson


"mathew" wrote:

> I'm sure this question will be a very easy one.
> I need to add a calculated number to a text field in an If statement but
> limit the number of decimal points.
> I have =IF(E28>0,"road system is "&E28,"good Job")
> Cell E 28 is a calculated percentage!
> How do I show this number as just a % in this If Statement?
>

[mathew]

Jim: It worked great. Thank you very Much!

"Jim Thomlinson" wrote:

> Try this...
>
> =IF(E28>0,"road system is "& Text(E28, "0.0%") ,"good Job")
> --
> HTH...
>
> Jim Thomlinson
>
>
> "mathew" wrote:
>
> > I'm sure this question will be a very easy one.
> > I need to add a calculated number to a text field in an If statement but
> > limit the number of decimal points.
> > I have =IF(E28>0,"road system is "&E28,"good Job")
> > Cell E 28 is a calculated percentage!
> > How do I show this number as just a % in this If Statement?
> >