If any-one of three cells less than a certain number, then return text

Hi,

I have numbers in A1, B1, and C2. I need a formula in D2 that says; If any of the numbers in any of these three cells is less than 60, then return the value "Out of Stock".

How do I do this?

Try this:

=IF(OR(A1<60,B1<60,C2<60),"Out of Stock","")

Legend!!!!!!!!!!!!!! Thank you so much. :-)

You're welcome. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.