Excel Formula Help
-
I have a spreadsheet for a split stake strategy and one of the columns has goal times (1-90 & NA indicating no goal). What formula would i use to return "NT" if the goal time is between 1-29 or "W" if the goal time is 30-69 and "L" if the goal time is 70-90 OR NA?
I could change the NA to a numeric value, say 100, however id like to avoid that if at all possible
-
@lee-woodman Try a vlookup or xlookup with True for approximate match instead of false for exact match?