If either of two cells falls between 0 and 90, then WJ

[Nanaia]

At some point I will be able to help more than asking for help.
I'm trying to get it so the selected cell will display "WJ" if cell Z2 or AA2 has a number greater than 0 but less than 90.
So far I have not been successful at getting it to work. You all are so knowledgeable that it's probably as easy as breathing... but I'm a work in progress.
Thanks for your help.
Regards,
Nanaia
"Do or do not, there is no try"~Yoda

 

[steve the fish]

You could use this

=IF(COUNTIFS(Z2:AA2,">0",Z2:AA2,"<90"),"WJ","something else")

 

[Nanaia]

Steve,
Simply put -- YOU ROCK! I'm learning so much from you it's making me giddy.
Thank you!
Nanaia
"Do or do not, there is no try"~Yoda

 

[cooper645]

My contribution comes from a different approach, but should still achieve the same result.

=IF(OR(AND($Z$2>0,$Z$2<90),AND($AA$2>0,$AA$2<90)), "WJ", "")