[FONT="]AND(logical1, [logical2], ...)
I have not been schooled in syntax if someone has a good beginner guide I would love to read it.
The question I have is on the [brackets] for the second logical2, why are there brackets there, what do they denote? When entering the logical2 data I am not required to enter [brackets] so why is it there?
I thought maybe brackets meant the second logical test is not required but when you are using an And, you need to have two logical test, perhaps the syntax should say And(logical1,logical2,[logical3]) if like I said they denote it may not be required for an AND formula to work.
thanks in Advance.
Rugman67[/FONT]
I have not been schooled in syntax if someone has a good beginner guide I would love to read it.
The question I have is on the [brackets] for the second logical2, why are there brackets there, what do they denote? When entering the logical2 data I am not required to enter [brackets] so why is it there?
I thought maybe brackets meant the second logical test is not required but when you are using an And, you need to have two logical test, perhaps the syntax should say And(logical1,logical2,[logical3]) if like I said they denote it may not be required for an AND formula to work.
thanks in Advance.
Rugman67[/FONT]