The syntax of the formula as you have written it here doesn't make sense--in particular, the quotes don't work. Is it supposed to be something like this:
That doesn't make sense either because the True result and the False result are identical.
It's hard to assess without knowing what's in F11, B7, and how the names Bow, Port, Stern, and Starboard are defined. The way you have written this formula, these are named ranges, not strings. Also, we can't tell what's negative and what's positive without knowing what is also in F17, F10, and D8.
Any chance that you could attach the file? (see yellow banner at the top of the page)
Bookmarks