View Single Post
  #3   Report Post  
Pat
 
Posts: n/a
Default

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




"Dave R." wrote in message
...
Try

=IF(OR(K14L14,J140),"Low stock","")


"Pat" wrote in message
...
=IF(K14L14,"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"