Countif statement from Excel to Calc [closed]

asked 2019-06-20 01:59:58 +0100

scubafool gravatar image

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)


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-06-20 18:57:08.967971



Try =IF(COUNTIF(Sheet2.A$1:$AK$99, E1)>0, TRUE,FALSE)

robleyd gravatar imagerobleyd ( 2019-06-20 05:32:49 +0100 )edit

That works, Thanks

scubafool gravatar imagescubafool ( 2019-06-20 13:15:50 +0100 )edit