Hello
I am attempting to create a formula where there are three options for results based on a range of numbers. My results need to be either the words Partner, Premier or a blank cell.
My struggle is the values of which each must be. If the number in a column is less than 6, it needs to be blank. If the number is 6 to 11, it needs to be Partner. If the number is 12 or more, it needs to be Premier.
I can get the IF function to work for the less than 6 or greater than 11. But the mid range is throwing me off. Any help would be greatly appreciated.
=IF(AND(C3>5,C3<12),"Partner","") is the formula I have. Blank and Partner are showing up, but not Premier.
I'm driving myself nuts here. lol
Bookmarks