Complex Formula Syntax error

Without going into any explanation of what my formula does, I wish to ask for help as the formula is not being accepted but the error is simply telling me there is and error, so I suspect it is simply a syntax problem.

My formula is

Please Login or Register  to view this content.

Could anyone suggest where the problem lies

Originally Posted by Palmetto

For every opening parethesis you must have a closing one.

Maybe this is what you need.

=if(or(and(),and()),"E","")

Thank you Palmetto, that was the fix. Had forgotten that the True, False values came at the end. The formula works fine now except that the logic is not how I want.

I Have some columns as follows:-

Please Login or Register  to view this content.

I am trying to get the start and end dates for any consecutive rows (dates) and am setting S when it finds the start of a group of consecutive records. This works fine. My problem is with the formula you help with to get the end of a group. The formula works fine if column D on the next row is blank, but does not work if Column D (next row) containes C. The only difference between the 2 AND statements is to test Column D.

Formula that works (thanks to you) is

Please Login or Register  to view this content.

The is something wrong with my logic I feel.