Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mindie
 
Posts: n/a
Default 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'
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

=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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding text to the result of a formula? Robbie in Houston Excel Worksheet Functions 2 February 28th 05 01:00 AM
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't Damaeus Excel Worksheet Functions 12 January 23rd 05 05:52 PM
Adding a formula to a pivot table Tony Excel Discussion (Misc queries) 2 January 20th 05 11:27 AM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 12:29 PM
Data Validation Formula Help Steve H. Excel Worksheet Functions 2 November 11th 04 10:38 PM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"