For Shane Devenshire

B

Bernie

Shane, ran the following formula and for F9=3 and it worked for the first
part; however, I entered data to ensure the second part of the formula when
F9=3 works and it gave me "NO GO" when it should've been "GO".

=IF(AND(F10=1,MIN(EW10,FA10,FD10)>DATE(2009,5,1)),"GO",IF(AND(F10=2,MIN(EW10,FA10,FC10,FD10)>DATE(2009,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,GA10,GB10,GC10)>DATE(2009,5,1),MIN(FA10,FD10,GA10,GB10,GC10,GD10)>DATE(2009,5,1))),"GO","NO GO")))

Did enter something wrong?
 
D

David Biddulph

I'm not Shane, but see your later thread.

It is normally better to keep your discussion in the same thread so that
people can see the previous discussion, rather than starting new threads.
 

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

Formula issue with the "OR" command 4
formula problem 5
replacing built in keyboard shortcuts with my macros? 2
SUMIF question - again 5
Weird problem with conditional format 4
Problem in automating using a button created by recording a macro 0
How do I format plain text to wrap around in a paragraph? 1

Top