Multiple AND

[Nikki]

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?

 

[bpeltzer]

It's just =IF(AND(test1,test2,test3),result_if_true,result_if_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)