+ Reply to Thread
Results 1 to 7 of 7

Formulas

  1. #1
    Registered User
    Join Date
    09-13-2005
    Posts
    7

    Formulas

    Is there any way to type a formula into a cell, but not make it active? I want to have the formula on the spreadsheet so that I can explain what it does, but I don't want the equal sign to appear because it will most certainly give me a value.

    This formula will add all the sums of E4 through E10
    =SUM(E4:E10)

    Like I said though, I don't want the cell that this formulas is in to have a value in there; only the formula itself must exist there.

    Thanks all.

  2. #2
    Registered User
    Join Date
    09-13-2005
    Posts
    7

    Formula

    I believe I found an answer to my question ...

    I inserted a comment field and I explained what the formula does and how they have to change the range of numbers to get a value.

    That might work for now, but I'm still curious if there is an answer to my original question.

    Thanks all.

  3. #3
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Try preceding your formula with an apostrophe when you enter it in the cell, e.g,

    '=sum(E4:E10)


    I hope this is what you are looking for.

    Regards.
    BenjieLop
    Houston, TX

  4. #4
    Don Guillett
    Guest

    Re: Formulas

    how about an ' before the =

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "excelrookie05" <excelrookie05.1vcqug_1126706771.765@excelforum-nospam.com>
    wrote in message
    news:excelrookie05.1vcqug_1126706771.765@excelforum-nospam.com...
    >
    > Is there any way to type a formula into a cell, but not make it active?
    > I want to have the formula on the spreadsheet so that I can explain
    > what it does, but I don't want the equal sign to appear because it will
    > most certainly give me a value.
    >
    > This formula will add all the sums of E4 through E10
    > =SUM(E4:E10)
    >
    > Like I said though, I don't want the cell that this formulas is in to
    > have a value in there; only the formula itself must exist there.
    >
    > Thanks all.
    >
    >
    > --
    > excelrookie05
    > ------------------------------------------------------------------------
    > excelrookie05's Profile:

    http://www.excelforum.com/member.php...o&userid=27204
    > View this thread: http://www.excelforum.com/showthread...hreadid=467490
    >




  5. #5
    Registered User
    Join Date
    09-13-2005
    Posts
    7

    Formulas

    Yea ... It worked !!!

    I appreciate the help BenjieLop and Don Guillett.

  6. #6
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Thank you for the feedback ...


    Regards.

  7. #7
    Don Guillett
    Guest

    Re: Formulas

    glad to help

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "excelrookie05" <excelrookie05.1vgdei_1126875995.387@excelforum-nospam.com>
    wrote in message
    news:excelrookie05.1vgdei_1126875995.387@excelforum-nospam.com...
    >
    > Yea ... It worked !!!
    >
    > I appreciate the help BenjieLop and Don Guillett.
    >
    >
    > --
    > excelrookie05
    > ------------------------------------------------------------------------
    > excelrookie05's Profile:

    http://www.excelforum.com/member.php...o&userid=27204
    > View this thread: http://www.excelforum.com/showthread...hreadid=467490
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1