I think you need to re-write it slightly:

=IF(AND(J1="X", K1="G"),"AAAAA",IF(AND(J1="X", K1="T"),"BBBBB",""))

Hope this helps.

Pete


On Jan 25, 8:16 pm, 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?