| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
=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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding text to the result of a formula? | Excel Worksheet Functions | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
| Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| Data Validation Formula Help | Excel Worksheet Functions | |||
Linear Mode
