ExcelBanter - formatting number in a text field

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formatting number in a text field (https://www.excelbanter.com/excel-programming/367244-formatting-number-text-field.html)

mathew

formatting number in a text field

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(E280,"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

formatting number in a text field

Try this...

=IF(E280,"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(E280,"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

formatting number in a text field

Jim: It worked great. Thank you very Much!

"Jim Thomlinson" wrote:

Try this...

=IF(E280,"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(E280,"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?

All times are GMT +1. The time now is 07:24 PM.