Excel is clearing the cell when i try to put this formula.

Hi im having an issue with Excel clearing the cell when trying to enter this formula.

=IF('Employee Data Years to Retire'!N1=1, 'Employee Data Years to Retire'!C1, "")

couldnt find anything related by googling. i tried getting some assistance from chatGPT it gave me these

=UNIQUE(FILTER('Employee Data Years to Retire'!$C:$C, 'Employee Data Years to Retire'!$N:$N=1))

=FILTER('Employee Data Years to Retire'!$C:$C, 'Employee Data Years to Retire'!$N:$N=1)

Anytime the second = in the formula is added the cell auto clears and nothing happens.

Ive tried turning off auto complete with no success. Any ideas? Thanks