Hi - I want to take a value and use a CASE or COALESCE (or IF ELSE END) statement to return different values depending on the source data (ie. compass degrees/45 -> N, NE, E, SE, S, SW, W, NW).
IF() only seems to handle true false, and would get ugly if I had to nest the IF’s for as many items as I needed to evaluate. Is there something like CASE/COALESCE and I am just missing it? Any other suggestions?