IF statement and WEEKDAY

[thart21]

I think I'm close but can't seem to get this one to work.

=IF((AND(E105<>"#",K105<E105)),"On Time",(IF((AND(K105-E105=3,WEEKDAY(K105=2),"On Time","Late")))

What I'm looking for:

(E and K are DATES)

IF E105 doesn't have a "#" AND K105 is less than E105, then it's "On Time" OR IF K105-E105=3 AND the WEEKDAY of K105 is a Monday(2), then it's "On Time", otherwise it's "Late".

It's just giving me the "formula contains an error" message but can't figure out where the problem is.

Thanks!

Toni

 

[Scott Huish]

=IF(OR(AND(E105<>"#",K105<E105),AND(K105-N(E105)=3,WEEKDAY(K105)=2)),"On Time","Late")<E105),AND(K105-N(E105)=3,WEEKDAY(K105)=2)),"ON p Time?,?Late?)<>

 

[CWatts]

Try this.

Undested:

=IF(AND(E105<>"#",K105<E105),"On Time",IF(AND(K105-E105=3,WEEKDAY(K105)=2),"On Time","Late"))

Provide some sample data if htat doens't work and I can refine it.

 

[thart21]

.

 

[Scott Huish]

The problem is the < you can put a space after it and it might help as this is the opening bracket for an HTML tag. Did my formula work for you?

 

[CWatts]

you can also use the html special character code

& lt ;

without the spaces. (lt = less than)

 

[thart21]

I don't know what happened to my post, but most of my formula did not make it.

Here is the actual formula I was trying to write.

IF((AND(E105<>"#",K105 < E105)),"On Time",(IF((AND(K105-E105=3,WEEKDAY(K105=2),"On Time","Late")))

Thanks for the help, your solutions worked great! I'll need to learn about the "N(E103)" part, haven't seen that in my searches yet.

Toni

 

[Scott Huish]

N function: http://office.microsoft.com/en-us/excel-help/n-HP005209187.aspx?CTT=1