if/and formulas
You're close, but you need to nest the second IF statment inside the False
condition of the first one. Like this:
=IF(AND(J1="X",K1="G"),"AAAAA",IF(AND(J1="X",K1="T "),"BBBBB",""))
HTH,
Elkar
"Chuckee" wrote:
Hi,
Is it possible to nest if/and formulas or is there a different way to do it.
Here is my simple example
=IF(AND(J1="X", K1="G"), "AAAAA",""),IF(AND(J1="X", K1="T"),"BBBBB","")
Now this gives a #value! error
Any ideas?
|