View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Cells only display formula

Check to see if this is the problem: Go to
'tools'...'options'....'view'....window options and see if there is a check
mark next to formulas. If there is uncheck that box.

"waladd" wrote:

all it is showing is the formula itself

"tim m" wrote:

It shows nothing at all in the cell the formula is in? I just tested the
formula and it worked when I put various things in Q34 on my sheet.

"waladd" wrote:

I have a formula that is not showing the result in the cells. Using fx button
shows result, but result does not show in cells. tried ctrl + ` to no avail,
formula is working.
ex. of formula:
=IF(Q34="ON","S",IF(Q34="PH","ON","OFF"))

any help or suggestions would be greatly appreciated