| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple AND
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple AND
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Linear Mode
