PC Review


Reply
Thread Tools Rate Thread

Cells only display formula

 
 
=?Utf-8?B?d2FsYWRk?=
Guest
Posts: n/a
 
      13th Jul 2006
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
 
Reply With Quote
 
 
 
 
Special-K
Guest
Posts: n/a
 
      13th Jul 2006

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

 
Reply With Quote
 
=?Utf-8?B?dGltIG0=?=
Guest
Posts: n/a
 
      13th Jul 2006


"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

 
Reply With Quote
 
=?Utf-8?B?dGltIG0=?=
Guest
Posts: n/a
 
      13th Jul 2006
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

 
Reply With Quote
 
=?Utf-8?B?d2FsYWRk?=
Guest
Posts: n/a
 
      13th Jul 2006
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
>
>

 
Reply With Quote
 
=?Utf-8?B?d2FsYWRk?=
Guest
Posts: n/a
 
      13th Jul 2006
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

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      13th Jul 2006
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


 
Reply With Quote
 
=?Utf-8?B?dGltIG0=?=
Guest
Posts: n/a
 
      13th Jul 2006
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

 
Reply With Quote
 
=?Utf-8?B?d2FsYWRk?=
Guest
Posts: n/a
 
      13th Jul 2006
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

>
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      13th Jul 2006
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Text in Formula Bar for certain cells Tracy Microsoft Excel Worksheet Functions 3 5th Nov 2008 05:30 PM
Display Zero only in Selected Cells using a formula Steved Microsoft Excel Worksheet Functions 8 7th Aug 2008 06:20 AM
Why does my formula bar display a lengthy string, but my cells display #####? akh2103@gmail.com Microsoft Excel Programming 2 23rd Aug 2006 06:43 PM
display formula instead of its values in some cells ah 3 Microsoft Excel Worksheet Functions 11 9th Jan 2006 03:59 PM
Need formula to display info across cells =?Utf-8?B?SW5kZXggZm9ybXVsYSBuZWVkZWQ/IFBscyBIZWxw Microsoft Excel Worksheet Functions 2 4th Jun 2004 06:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:03 AM.