HELP GUYS, CAN'T WRITE IF FORMULA FOR EXCEL

Help
, , ,
1

hallo guys,
please help me, i’ve got error while use write cell and input formula.
Error

my Formula in excel :
=IF(COUNTIF($C$2:$C$200, C173)>1, “Duplikat”, “”)

please help me T_T

2

@Theodorus_Pratama

May I know what error are you getting here ?

3

Kindly try with this expression
=IF(COUNTIF($C$2:$C$200, C173)>1, “”“Duplikat”””, “”“”””)

That is surround the double quotes with two double quotes like this (in Split way only for easy understanding)

=IF(COUNTIF($C$2:$C$200, C173)>1,
“ “ “Duplikat” “ “,
“ “ “” “ “)

Hope this would help you
Cheers @Theodorus_Pratama