Help with Formula

[stew]

Hi can anybody see an error in this Formula which is in E46 on a different
worksheet

=IF(AND(INDIRECT("'Date
Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2)))="GB",INDIRECT("'Date
Details'!"&ADDRESS(7,(INT(ROW()/1-45)+2))))="REHEARSALS","REHEARSALS",INDIRECT("'Date Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2))))

It should do the following
If the 2 conditions
date details C6 =GB AND date details C7 = Rehearsals the result should read
Rehearsals
At the moment it is returning date details C6

Thanks for looking

Stew

 

[stew]

Found It

Parenthesis in the wrong placee

=IF(AND(INDIRECT("'Date
Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2)))="GB",INDIRECT("'Date
Details'!"&ADDRESS(7,(INT(ROW()/1-45)+2)))="Rehearsals"),"Rehearsals",INDIRECT("'Date Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2))))

 

[stew]

Dear David

I actually found the actual mistake, as you can see.

This project I am doing started with me having no knowledge of excel so I do
come back to Formulas all the time and simplfy them. Thanks for your help

best

stewart