if and or formula
Hi I try to build a formula for 1st row in yellow. I have 2 drop down filters and I would like to get the deadline shown in deadline1 as a result of the lead time and TLT combination.
e.g. Lead time 60 and TLT 105 give me result deadline 15/11/23
this is working with
=IF(AND([Lead Time]1 = "60", [TLT]1 = "105"), [Deadline]6)
But now I'm not sure how to integrate the other combinations in the formula.
Help Article Resources
Check out the Formula Handbook template!