Good Morning,

I am having a bit of trouble with a formula. Here is what I am trying to accomplish:

if

(F2) = (I2)
then
"Required Parts On Order"
else
if


(F2) = (L2) and (K2) = 0
then
"Required Parts Pulled From Inventory"
else
if
(F2) = (M2)
then
"Quantity Ordered has Arrived"
else
if
(J2)<>(I2)
then
"Parts Waiting for Order"
else
if
(J2) = 0 and (I2) = 0
then
"PART IS NOT IN PROCUREMENT STATUS"



I have tried using nested "ifs", but when there are two criteria it is throwing me off.

Thanks in advance

To get you started : IF(F2=I2,text_1,if(and( F2=L2,K2=0),text_2,....

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you so much for this. It worked beautifully.