ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding an extra validation to this formula. (https://www.excelbanter.com/excel-discussion-misc-queries/16517-adding-extra-validation-formula.html)

Mindie
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=F ALSE)),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
=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=FAL SE)),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=F ALSE)),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


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com