Inside the cell it shows the formula, not the answer

[BHammy]

I was using

=IF($B3>0,INDEX('Open+Shipped'!$AA:$AD,Summary!$B3,3),"No")

as a function. I tried editing it to become

=IF($B3>0,INDEX('Open+Shipped'!$AA:$AD,Summary!$B3,4),"No")


Now, instead of saying "No" in the cell, it says

=IF($B3>0,INDEX('Open+Shipped'!$AA:$AD,Summary!$B3,4),"No")


What is wrong? Do I need to change formatting or something?

Thanks everyone!

[robertswart]

The cell is either formatted as text, change that to general formatting, or you have to press "show formulas" in the formulas tab.