maybe we can do this way also
=IF((J1&K1="XG"),"AAAAA",IF((J1&K1="XT"),"BBBBB"," "))

--
*****
birds of the same feather flock together..



"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?