Multiple Arguments for IF
Unsure if that's what I even need he I have no clue what I'm doing.
I've attached what I'm working on: Basically I need assistance with 2 things-
1) Currently my function in column D is: IF(E15="","Active","Banned")
I'd like an additional option: Blank= Active, Any number = Banned "Perm" = Permed
2) Is there a way to sort the list with Active at top, followed by Banned, and having Permed at the bottom?
Thanks for any help!
|