Cant seem to work this one out and wondered if you guys can help.

I have the following formula in Cell C1

=IF(AND(A1="TRUE",B1="TRUE"),"Yes","No")

Some of my results show as #N/A, and i would like to add to the formula so my results will not show as the #N/A when the references cells have no data in.

I have tryed ISNA, NOT but cant seem to get it lol

Please help.

Cheers All.