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