Sorry, I meant to say:

=IF(COUNT(F2,J2)=2,IF(J2F2,"Text Label A","Text Label B"),"")

But this will consider also real 0's in F2 and J2 as a hit.

RJJ wrote:
I've tried your suggestion but, the text label changes accordingly with
regards to greater than or less than however a text label is present in K2
even if no numbers are entered in J2 & F2.

"Aladin Akyurek" wrote:


=IF(COUNT(F2,J2),IF(J2F2,"Text Label A","Text Label B"),"")

RJJ wrote:

In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being
greater than or less than F2 but only if a value has been entered into J2 and
F2. I would not want any value in K2 if no values are entered into J2 and F2.
This is what I am attempting but not working. Any suggestions?

=IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B")