Nested IF AND returning #VALUE!
Hi Paul,
Am Thu, 7 Jul 2016 22:27:58 -0700 (PDT) schrieb Paul Doucette:
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))))
Regards
Claus B.
--
Windows10
Office 2016
|