ExcelBanter - Multiple AND

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple AND (https://www.excelbanter.com/excel-discussion-misc-queries/190918-multiple.html)

Hi,

I would like to create an IF AND statement that says if this and this and
this then do this.

I used this one for 2 AND parts and it worked
=IF(AND('Car Parks - AKO'!A5='Site Allocation - AKO'!C45,N7=0),'Car Parks -
AKO'!B5*'Car Parks - AKO'!$B$2,0)

I have tried this one to add another variable and it doesnt work.
=IF(AND('Car Parks - AKO'!A7='Site Allocation -
AKO'!C85,N47=0,AND(N9=0),'Car Parks - AKO'!B7*'Car Parks - AKO'!$B$2,0))

Any suggestions?

It's just =IF(AND(test1,test2,test3),result_if_true,result_i f_false) :
=IF(AND('Car Parks - AKO'!A7='Site Allocation -
AKO'!C85,N47=0,N9=0),'Car Parks - AKO'!B7*'Car Parks - AKO'!$B$2,0)

"Nikki" wrote:

Hi,

I would like to create an IF AND statement that says if this and this and
this then do this.

I used this one for 2 AND parts and it worked
=IF(AND('Car Parks - AKO'!A5='Site Allocation - AKO'!C45,N7=0),'Car Parks -
AKO'!B5*'Car Parks - AKO'!$B$2,0)

I have tried this one to add another variable and it doesnt work.
=IF(AND('Car Parks - AKO'!A7='Site Allocation -
AKO'!C85,N47=0,AND(N9=0),'Car Parks - AKO'!B7*'Car Parks - AKO'!$B$2,0))

Any suggestions?