Return answer if.....

[Pat]

=IF(K14>L14,"Low stock","")

I want to add into the above formula a condition where if J14 has a value
greater than 0 then return the message "Low stock"

 

[Dave R.]

Try

=IF(OR(K14>L14,J14>0),"Low stock","")

 

[Pat]

Having re-examined the problem I am afraid I have explained the problem
incorrectly.

=IF(K14<=L14,"Low stock","")

If I could include into the formula a condition that "Low stock" will only
be returned if J14 is greater than L14

 

[Fredrik Wahlgren]

Having re-examined the problem I am afraid I have explained the problem
incorrectly.

=IF(K14<=L14,"Low stock","")

If I could include into the formula a condition that "Low stock" will only
be returned if J14 is greater than L14

I think this is what you want.
=IF(AND(K14>L14,J14>L14),"Low stock","")

/Fredrik