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"
|