View Single Post
  #1   Report Post  
Chelli Chelli is offline
Junior Member
 
Posts: 1
Default 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!
Attached Images