I am working on an IF AND statement in google sheets where the return is one of five words. However, I would like the statement to run only if the value in another cell - in my case, in column J, same row - is "Yes"
I've got the basic IF AND working, but I don't know how to tell Google sheets to only perform the statement if J2, J3, J4, etc is "Yes"
I also need this statement to not return anything until there are values in the row...I think that's probably just another IF AND part to what I have and a "" at the end for the if false part - but I modified a nested IF AND I found here to get what you see below so I'm not sure what if any parenthesis would need to be added
Here's what I have:
=IF(AND(X2 > 0,X2 < 14),"Developing",IF(AND(X2 > 13,X2 < 27),"Emerging",IF(AND(X2 > 26,X2 < 40),"Expanding",IF(AND(X2 > 39,X2 < 53),"Accomplished","Transferred"))))
Here's my google sheet: HEAR Audit
I'm sure this is simple, but I'm completely new to Nesting IF AND statements, so help is appreciated.