I am editing an Excel file that a person who no longer works here created. I need to change the year that a T.TEST runs for. The formula starts out {=T.TEST(IF... and ends with ...)}. Every time I even click into the formula bar, the { } goes away, and no matter what, even if I have not edited the formula, it comes back #VALUE!.
What do the { } mean? How can I edit these? Please help.
Formula:
{=T.TEST(IF(('Reference'!$B$2:$B$2316=Input!$C$4)*('Reference'!$D$2:$D$2316=2)*('Reference'!$F$2:$F$2316>2013),'Reference'!H$2:H$2316),IF(('Reference'!$B$2:$B$2316<>Input!$C$4)*('Reference'!$D$2:$D$2316=2)*('Reference'!$F$2:$F$2316>2013),'Reference'!H$2:H$2316),2,3)}
Thanks,
Bookmarks