I’m trying to make sheets calculate my delivery times based on which locations the items are shipped between.
Tried combining the Ifs and
AND formulas, but I keep getting errors.
(Let’s say the delivery time between London and Barcelona is 5 days. Delivery time between Stockholm and Madrid is 6 days. A3=today’s date)
My formula looks like this right now:
=Ifs(And(A1=London,A2=Barcelona), A3+5, AND(A1=Stockholm,A2=Madrid), A3+6
And so on. I have at least 11 different delivery times depending on destinations. How can I make this formula run?