Complex IF formula

[Legacy 469343]

Hi everyone,

I hope I can explain in detail, what I need.

Cell J12 reflects the required date of drawing 101 for PO 123456. For this I used the formula: =IF(ISBLANK($B12),"",$B12+14)
Cell J13 needs to reflect the required date of drawing 102, based on the date drawing 101 was sent back to the manufacturer + 2 weeks, which is reflected in cell N12. But still linked to PO 123456. But also only when the status of drawing 101 is status 1.

And above I also need for the next Company / PO 123457.

How can I do this?

Link to Excel file: Sheet.xlsx

 

[Calv1]

Hi, if I understood this correctly. How about this formula in Cell J13?

=IF(AND(E13=E12,I12=1),N12+14,"")

Edit :

Or this to keep the column empty and neater until the drawing has been sent back.

=IF(N12="","",(IF(AND(E13=E12,I12=1),N12+14,"")))

 

[Legacy 469343]

Yes! Looks like what I'm looking for, thanks!