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