Adding an extra validation to this formula.

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'

=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)

Mindie wrote:
> 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'


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html