Display formula result

Copper Contributor


I have a formula "If" in a cell and the result does not display. I have the detail of the formula instead of a result. 

Could you please help me?

I try to modify parameter "Formula"/"Display formula" but nothing...

(Sorry for my english, hope you understand me well).

Thank you for your help.


1 Reply


Make sure that the cell with the formula is not formatted as Text.

If it is, set the number format to something else, for example General. Then press F2 followed by Enter.