Change your formula as shown below
if will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Killer. Thanks, Jim! Now making changes to the special values settings actually functions as well. "Show at Default Value" drops the line to zero and "Hide (Break Lines)" removes the data.
Thanks Glad to help out