This is my formula:
="Total Installation "&TEXT('Project Worksheet'!$Z$4,"$0,0.00")
assuming that Z4 is equals to $1466.25
this is my answer:
Total Installation $1,466.25
But if Z4 is equals to $0.00
I want my answer to:
"Installation is not included"
Thank you in advance for your help.
Miguel.
