View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mathew mathew is offline
external usenet poster
 
Posts: 75
Default 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?