View Single Post
  #4   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



"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