I have an oddity when I'm at home in Minneapolis (not an issue in other locations in the city). The Zooper location often changes to Tonopah (2000 miles from here) or Tomah (100 miles from here). I have written a formula to deal with one instance of this error which causes the temperature to not show if Tonopah is the location (I doubt I'll ever spend any time there ;) ). However, I would like to write a single formula that would return a blank if either city were the location. Here's my current working formula:
$#LLOC#!=Tonopah?#WCTEMPN#: $ (A space just before the last $)
Any ideas how I can write this to include both cities?
Thanks in advance.
-Bob-
$#LLOC#!=Tonopah?#WCTEMPN#: $ (A space just before the last $)
Any ideas how I can write this to include both cities?
Thanks in advance.
-Bob-
Aucun commentaire:
Enregistrer un commentaire