yes the problem is that even if T2 and U2 are not equal to 0 - it is giving
me the value of Q2 as the answer

"The Code Cage Team" wrote:


Your formula =IF(AND(AA2="p",Q2="0",U2="0",T2="nil"),0,Q2 ) will return
0 if true and the contents of Q2, is this what you want?Mary-Anne;176953 Wrote:
Hi, I'm trying to create an answer using a combination of "and" and
"if"
statements for a number of cells - without success. I've done the
following
formula =IF(AND(AA2="p",(Q2="0"),(U2="0"),(T2="nil")),0,Q2 ). Can
anyone help
me with what I'm missing to make the formula look for the "true" or
"false"
result across the 4 cells? Thanks


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48951