Hello,
How can I shorten this
Basically it is the part of the longer formula
How can I shorten this
AND('[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!E5<>"instrument air",'[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!E5<>"steam")
Basically it is the part of the longer formula
IF('[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!E5="","",IF(AND('[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!E5<>"instrument air",'[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!E5<>"steam",'[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!J5<425,'[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!I5>40),'[Copy_BIB_Instrument List P0_20160530.xlsx]PI'!B5,""))