Hiding Formula in locked cell

[a580688]

Hi,

Can anyone help me in hiding formula's in locked cells. I don't want anyone to see the formula in the formula bar. I have protected the sheet myself and i am using excel 2010.

The formula is

{=IFERROR(INDEX('Sheet 3'!L$2:L$20,SMALL(IF(COUNTIF($D$2:$D$3,'Sheet 3'!$N$2:$N$20),ROW('Sheet 3'!L$2:L$20)-ROW('Sheet 3'!L$2)+1),ROWS(A$2:A2))),"")}

Thanks in advance.

 

[bbott]

When you format the cell, check the 'Hidden' box on the protection tab.