Hi,

I have the below formula which works fine.

=IF(AND(F14="PASS",G14="PASS"),E14,"39v")
However I need to add another condition so that 'DEFER' is entered if any of E14,E14 or G14 = 'DEFER'

This would take precedence over any of the conditions in the above formula.

Any suggestions?

Thanks