Quote:
Originally Posted by nickerjones
Wow .. Thanks...Ya'll just cut my "making reports" time in half...
If I ever had to make a note in one of the cell such as ... C2 is open , Last full in 2007 . Is it possible to have "Last full in 2007" in the same cell as the formula. I have tried inputting it in and it just messes the formula up.
|
You have to use the function "&" so you would change the formula where you want the phrase to appear to this: =IF(B1=0,"This area is full","This area is open")&" " & "last full in 2007"