Adding an extra validation to this formula.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to copy value from 2nd file, if a word found in a correspondingrow of both files 5
Cell keeps give me an #valid error 2
Time entry with VBA 3
How to insert line of text on other worksheet depending upon result in a cell? 3
How to insert line on other worksheet depending upon result in cell? 4
VBA Formula Help 6
array or IF formula excel help 2
formula using data validation 5

Back
Top