IF AND functions
'nil' is the literal word
"T. Valko" wrote:
I'm confused!
Is nil slang for an empty cell or do you mean the literal word nil?
--
Biff
Microsoft Excel MVP
"Mary-Anne" wrote in message
...
Hi Biff, I think maybe my assumptions of true vs false may be the problem.
Column Q is either value or 0, column T is either nil or something else
(alpha numeric combinations) row U is 0 - 4. If there is value - more than
0
in Q and either nil or 0 in T or U columns I want it to to give me the
value
of Q. Currently with the below formulas it gives me the value of Q whether
U
or T meet my true criteria or not.
"T. Valko" wrote:
=IF(AND(AA2="p",(Q2="0"),(U2="0"),(T2="nil")),0,Q 2)
You don't want to quote numbers: "0"
Try it like this:
=IF(AND(AA2="p",Q2=0,U2=0,T2="nil"),0,Q2)
--
Biff
Microsoft Excel MVP
"Mary-Anne" wrote in message
...
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
|