Adding an extra validation to this formula.

M

Mindie

Here is the formual and here is what I am trying to add to it.

=CONCATENATE(IF(Monday!R33="4D","EST 4D",Monday!R33),"
",IF(OR(AND(F34=TRUE,G34=TRUE),AND(F34=FALSE,G34=FALSE)),H34,IF(F34=TRUE,"X","Y"))," ",Monday!D33)

I would like to add if B34=True, Put in Monday!A5 and "Z" in instead of H34
or "X" OR "Y'
 
D

Debra Dalgleish

=IF(Monday!R33="4D","EST 4D",Monday!R33)&" "&
IF(B34=TRUE,Monday!A5 & " Z",
IF(OR(AND(F34=TRUE,G34=TRUE),AND(F34=FALSE,G34=FALSE)),H34,
IF(F34=TRUE,"X","Y"))&" "&Monday!D33)
 
Top