I have an IF statement that use the AND function, im having difficulty adding more arguments to my statement as shown below:
=IF(AND(AP33=7)*AND(AX19=35),AP27,AQ27)
I want to add in:
AND(AP33<>7 AND AX19<>35), AP22)
I have tried:
=IF(AND(AP33=7)*AND(AX19=35)*(AP33<>7)*AND AX19<>35),AP27,AQ27, AP22,AP22)
I am thinking i need an OR function in somewhere.
Bookmarks