View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
waladd waladd is offline
external usenet poster
 
Posts: 10
Default Cells only display formula

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