Hello,

Can I edit the formula below to include another criteria

=IF(OR(ISNUMBER(SEARCH("SEA",H2)),ISNUMBER(SEARCH( "EXPORT",H2)),ISNUMBER(SEARCH("K",H2))),C2+32,C2+7 )

The formula looks up Sea, Export or K within col H and if true will add 32
days onto the value in Col C, if not true it will just add 7 days.

I have a part number which will take longer to arrive than 32 days so I need
to include this in the calculation.

The formula needs to include a search in col D and if BCRFRMXX00002 is found
add 42 days to the value in col C regardless to the value in Col H .

Col H is the method of shipment

This would need to be the first search criteria.

I have tried

=IF(OR(ISNUMBER(SEARCH("BCRFRMXX00002",D2)),C2+42, ISNUMBER(SEARCH("SEA",H2)),ISNUMBER(SEARCH("EXPORT ",H2)),ISNUMBER(SEARCH("K",H2))),C2+32,C2+7)

Can you please advise me.

ManyThanks

Winnie