I'm trying to build an IF statement that tests if a condition exists in
two columns, and assigns the number 1 if it does, and 0 if not. The
columns being checked are vLookups which return #NA if an ID is not
found in another table. I'm trying to search for cases where an ID# IS
returned in two columns meaning the record shows up in both tables.
I can't figure out the syntax for this. I've tried
IF(AND(A1<>"#NA"; B1<>"#NA"),1,0)
on both the vlookup formula columns and on columns that are pasted
without formulas. No luck yet. Can someone chime in on this?
Many thanks in advance.
--
Carl Paulsen
Dover, NH 03820
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted