ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Function Key not doing what it needs to (https://www.excelbanter.com/excel-discussion-misc-queries/224701-function-key-not-doing-what-needs.html)

E.P.

Function Key not doing what it needs to
 
Good morning,
I work with various functions, and I'm not sure if I turned something off or
whats going on. After I do the =(Function) it doesn't show the result, rather
the equation.
Any insight.
Thank you so much!


PJ

Function Key not doing what it needs to
 
Maybe the cell where you are entering your function is formatted as text?

"E.P." wrote:

Good morning,
I work with various functions, and I'm not sure if I turned something off or
whats going on. After I do the =(Function) it doesn't show the result, rather
the equation.
Any insight.
Thank you so much!


Bob I

Function Key not doing what it needs to
 
In Options you have a tick in the Box for
"Show formulas instead of their calculated results"

E.P. wrote:

Good morning,
I work with various functions, and I'm not sure if I turned something off or
whats going on. After I do the =(Function) it doesn't show the result, rather
the equation.
Any insight.
Thank you so much!




All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com