On Friday, July 8, 2016 at 4:09:03 AM UTC-4, Claus Busch wrote:
Hi Paul,

Am Fri, 8 Jul 2016 09:42:55 +0200 schrieb Claus Busch:

IF(AND(ER18=TRUE,ET18=TRUE),ER22),IF(AND(ER18=FALS E,ET18=TRUE),ER23),IF(AND(ER18=TRUE,ET18=FALSE),ER 24),IF(AND(ER18=FALSE,ET18=FALSE),ER25)

try:
=IF(AND(ER18=TRUE,ET18=TRUE),ER22,IF(AND(ER18=FALS E,ET18=TRUE),ER23,IF(AND(ER18=TRUE,ET18=FALSE),ER2 4,IF(AND(ER18=FALSE,ET18=FALSE),ER25))))

a little shorter:
=INDEX(ER22:ER25,MATCH(--ER18&--ET18,{"11","01","10","00"},0))


Regards
Claus B.
--
Windows10
Office 2016

So, you are like, a genius. :-) And you,ve made my day! THANK YOU!
Paul