#1
|
|||
|
|||
Multiple If statements
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thank you so much for this. It worked beautifully.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple If statements, | Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
Please tell me it doesn't take 7 statements to turn table borders off | Jennifer Murphy | Word VBA | 5 | 07-25-2012 03:12 PM |
showing results of If statements in a mail merge | m&co | Mail Merge | 3 | 01-06-2012 07:27 PM |
Multiple VLOOKUP's checking multiple Cells | OTPM | Excel | 11 | 05-23-2011 11:18 AM |
IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |