New to LibreOffice from Excel. I uses the below formula to see if the numbers on one sheet are in the other and then give a true or false statement. This is written in Excel. Can some one help me with converting it to LibreOffice Calc please?
=IF(COUNTIF(Sheet2!$A$1:$AK$99, E1)>0, TRUE,FALSE)