+ Reply to Thread
Results 1 to 2 of 2

Enter data and display function result in same cell

Hybrid View

  1. #1
    ChrisR
    Guest

    Enter data and display function result in same cell

    I was wondering if it is possible to enter a value in a cell and return a
    percentage from this value in the same cell.

    Example (using n=100)

    20 (20.00%)
    40 (40.00%)

    Here, 20 and 40 are entered values while the complimenting percentages are
    calculated and displayed in the same cell. The cells will need to display
    both the entered values and calculated percentages.

    Thanks in advance,
    Chris

  2. #2
    Nikki
    Guest

    RE: Enter data and display function result in same cell

    if understand your questions:

    highlight cells-- go to format-->selelct cell-->number-->percentage--ok

    now when you type 20 you will get 20%

    "ChrisR" wrote:

    > I was wondering if it is possible to enter a value in a cell and return a
    > percentage from this value in the same cell.
    >
    > Example (using n=100)
    >
    > 20 (20.00%)
    > 40 (40.00%)
    >
    > Here, 20 and 40 are entered values while the complimenting percentages are
    > calculated and displayed in the same cell. The cells will need to display
    > both the entered values and calculated percentages.
    >
    > Thanks in advance,
    > Chris


+ 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