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

You sure you havent got white text on a white background or similar
Formula is indeed correct and works as you indicated

--
Special-
-----------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...nfo&userid=747
View this thread: http://www.excelforum.com/showthread.php?threadid=56117

"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

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

Black text, white background (no color).

"Special-K" wrote:

>
> You sure you havent got white text on a white background or similar?
> Formula is indeed correct and works as you indicated.
>
>
> --
> Special-K
> ------------------------------------------------------------------------
> Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
> View this thread: http://www.excelforum.com/showthread...hreadid=561173
>
>

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

Sounds like cell(s) formatted as text.

Re-format to general then F2 and ENTER

If you have a great whack of these to do.............

Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

On Thu, 13 Jul 2006 09:22:02 -0700, waladd <(E-Mail Removed)>
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

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

That did it, thanks. Feel a little dumb now, but thank you lol

"Gord Dibben" wrote:

> Sounds like cell(s) formatted as text.
>
> Re-format to general then F2 and ENTER
>
> If you have a great whack of these to do.............
>
> Edit>Replace
>
> What: =
>
> With: =
>
> Replace all.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 13 Jul 2006 09:22:02 -0700, waladd <(E-Mail Removed)>
> 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
>
>

Very common problem so don't feel too dumb.

Gord

On Thu, 13 Jul 2006 11:09:02 -0700, waladd <(E-Mail Removed)>
wrote:

>That did it, thanks. Feel a little dumb now, but thank you lol
>
>"Gord Dibben" wrote:
>
>> Sounds like cell(s) formatted as text.
>>
>> Re-format to general then F2 and ENTER
>>
>> If you have a great whack of these to do.............
>>
>> Edit>Replace
>>
>> What: =
>>
>> With: =
>>
>> Replace all.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Thu, 13 Jul 2006 09:22:02 -0700, waladd <(E-Mail Removed)>
>> 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
>>
>>

Gord Dibben MS Excel MVP