Here's my formula
=AND([@[Tenure (Yrs)]]>=5,[@[2016 Sales]]>=150000)
(where should i enter high and low? Do i need an if formula nested into it?)
i'm trying to get it to read if the customer reads both critiera which is they've been there 5 years and over 150000 sales = High
if not Low
Bookmarks