=IF(I12="Y", J12*K$11, 0)
But, if I12
is blank, it calculates J12*K$11
anyway.
I've tried text, general and number formats for I12
. This calculation works as a test in a new worksheet. J12 is a link to a separate workbook.
Seems like the workbook you're working in got corrupted.
Try copying the worksheets to a new workbook by right clicking the sheet tab name, "Move or copy", new book. Then save that as the new working copy.
F9
and see if that does anything.