I
Iona
Hello,
I was wondering if someone can help me figure out why I receive the error
message "#VALUE!" with the formula below. I am evaluating dates. Thank you.
=IF(AND($D:$D<100%,$K:$K>TODAY()),"Review
Only",""),IF(AND($D:$D<100%,$K:$K<TODAY()),"Behind
Schedule",""),IF(AND($D:$D=100%,$K:$K<$J:$J),"Completed
Late",""),IF(AND($D:$D=100%,$K:$K>$J:$J),"Completed Ahead of Schedule","")
I was wondering if someone can help me figure out why I receive the error
message "#VALUE!" with the formula below. I am evaluating dates. Thank you.
=IF(AND($D:$D<100%,$K:$K>TODAY()),"Review
Only",""),IF(AND($D:$D<100%,$K:$K<TODAY()),"Behind
Schedule",""),IF(AND($D:$D=100%,$K:$K<$J:$J),"Completed
Late",""),IF(AND($D:$D=100%,$K:$K>$J:$J),"Completed Ahead of Schedule","")